Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)