Multiple Selection of Categories

Solved5.88K viewsFormulas and Functions

In matrix2. For category item how can I select E5 and E4 simultaneously.


S A U Changed status to publish October 30, 2018


The filter capabilities that you describe don’t quite work the same way in Quantrix as they do in Excel. Perhaps this video Episode 190 of the Quantrix Authority ( will give you some direction on how to accomplish what you desire. This demonstrates how robust Quantrix can be as compared to that lesser program.


Awesome, ShriShank.
At first you posted this topic in the Formulas and Functions section of the forum. And then you say that your question doesn’t concern formulas.

S A U Edited answer October 30, 2018

Thanks for the reply. What I meant was from the dropdown menu can I select E4 AND E5 simultaneously. As is possible in excel.
Do I need to use a canvas for doing this??


If I understand you correctly, try this formula in Matrix2:

  • : = Join(Select(@Item, OR(@Item = “E5”, @Item = “E4”), 1), “, “)
S A U Edited answer October 30, 2018