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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Fig1
Contributor III
Contributor III

exclude data based on field in qliksense pivot

I am a crystal user starting Qliksense so am very very new to this space.  I have created a pivot table in a new sheet and one of the rows is based on a field that will bring through data for three options - New, Review, Other.  I want to exclude the data and field where the field = 'Other', is this possible?

 

1 Solution

Accepted Solutions
saminea_ANZ
Creator
Creator

May be 2 ways to remove?

Expression level : Sum({<Field -= {'Others'}>} Measure)

Dimension Level : If(Not Match(Field, 'Others'), Field)

I can think other way which will come, You can disable "Others" check box in dimension If it is coming as default.

View solution in original post

1 Reply
saminea_ANZ
Creator
Creator

May be 2 ways to remove?

Expression level : Sum({<Field -= {'Others'}>} Measure)

Dimension Level : If(Not Match(Field, 'Others'), Field)

I can think other way which will come, You can disable "Others" check box in dimension If it is coming as default.