Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.