Solved: Re: Calculation Condition - Qlik Community

Anonymous · ‎2017-07-03

Hi - I have a pivot table which I want to disable whenever a value in field is not deselected.

So I have field - SECTOR - which has 3 possible values - A, B or C, if C is not deselected I don't want the pivot to calculate.

Thanks in advance!

Nandy

Gysbert_Wassenaar · ‎2017-07-03

Try this as calculation condition: =If(max(match(SECTOR,'C')),0,1)

talk is cheap, supply exceeds demand

View solution in original post

Anil_Babu_Samineni · ‎2017-07-03

Will you able to explain little more, Please?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Gysbert_Wassenaar · ‎2017-07-03

Try this as calculation condition: =If(max(match(SECTOR,'C')),0,1)

talk is cheap, supply exceeds demand

Anonymous · ‎2017-07-03

That looks like it's doing the job!

Thanks for the quick response!

Nandy