Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I filter the dimension values using set analysis in QSense? For eg: Size dimension has ('XL','L','M','S','XS')
I want to filter values for size dimension so that it only displays L, M and S
Size |
L |
M |
S |
SUM( {<Size={L,M,S}>} Value)
By using Sum i think it will change the column to measure. Is there a way to display as a Dimension only?
You can use If
If(Size='L' or Size='M' or Size='S',Size)
or
if you want the set analysis but I suggest use the If
Aggr(Only( {<Size={L,M,S}>} Size),Size)