topic Re: Calculation Condition in QlikView https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316160#M408623 <HTML><HEAD></HEAD><BODY><P>Will you able to explain little more, Please?</P></BODY></HTML> Mon, 03 Jul 2017 13:27:14 GMT Anil_Babu_Samineni 2017-07-03T13:27:14Z Calculation Condition https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316159#M408622 <HTML><HEAD></HEAD><BODY><P>Hi - I have a pivot table which I want to disable whenever a value in field is not deselected.</P><P></P><P>So I have field - SECTOR -&nbsp; which has 3 possible values - A, B or C,&nbsp; if C is not deselected I don't want the pivot to calculate.</P><P></P><P>Thanks in advance!</P><P>Nandy</P></BODY></HTML> Mon, 03 Jul 2017 13:16:45 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316159#M408622 Anonymous 2017-07-03T13:16:45Z Re: Calculation Condition https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316160#M408623 <HTML><HEAD></HEAD><BODY><P>Will you able to explain little more, Please?</P></BODY></HTML> Mon, 03 Jul 2017 13:27:14 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316160#M408623 Anil_Babu_Samineni 2017-07-03T13:27:14Z Re: Calculation Condition https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316161#M408624 <HTML><HEAD></HEAD><BODY><P>Try this as calculation condition: =If(max(match(SECTOR,'C')),0,1)</P></BODY></HTML> Mon, 03 Jul 2017 13:29:36 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316161#M408624 Gysbert_Wassenaar 2017-07-03T13:29:36Z Re: Calculation Condition https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316162#M408625 <HTML><HEAD></HEAD><BODY><P>That looks like it's doing the job!</P><P></P><P>Thanks for the quick response!</P><P>Nandy</P></BODY></HTML> Mon, 03 Jul 2017 13:32:31 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition/m-p/1316162#M408625 Anonymous 2017-07-03T13:32:31Z