Multiple Selection of Categories

Solved5.88K viewsFormulas and Functions
0

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

Thanks

S A U Changed status to publish October 30, 2018
1

ShriShank,

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 (https://www.youtube.com/watch?v=B6zxfvRgWSE) 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.

0

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
0

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??

0

Hi,
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