Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MH376
Contributor II
Contributor II

Set Analysis to filter dimension values

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
Labels (3)
3 Replies
menta
Partner - Creator II
Partner - Creator II

SUM( {<Size={L,M,S}>} Value)

MH376
Contributor II
Contributor II
Author

By using Sum i think it will change the column to measure. Is there a way to display as a Dimension only?

menta
Partner - Creator II
Partner - Creator II

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)