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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.