topic How to limit the pivot table expressions in QlikView https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400442#M424608 <HTML><HEAD></HEAD><BODY><P>I have a pivot table in which below are dimensions and expressions:</P><P></P><P>Category (Dimension)</P><P>Region (Dimension)</P><P>Area (Dimension)</P><P>Total Cost (Expression)</P><P>Total Vol (Expression)</P><P></P><P>By default, pivot table will show both expression but I want, when user expand area dimension, then only he/she will be able to see the total cost (Expression) otherwise Only Total Vol should be visible.</P></BODY></HTML> Mon, 14 Aug 2017 18:53:48 GMT vipingarg23 2017-08-14T18:53:48Z How to limit the pivot table expressions https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400442#M424608 <HTML><HEAD></HEAD><BODY><P>I have a pivot table in which below are dimensions and expressions:</P><P></P><P>Category (Dimension)</P><P>Region (Dimension)</P><P>Area (Dimension)</P><P>Total Cost (Expression)</P><P>Total Vol (Expression)</P><P></P><P>By default, pivot table will show both expression but I want, when user expand area dimension, then only he/she will be able to see the total cost (Expression) otherwise Only Total Vol should be visible.</P></BODY></HTML> Mon, 14 Aug 2017 18:53:48 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400442#M424608 vipingarg23 2017-08-14T18:53:48Z Re: How to limit the pivot table expressions https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400443#M424609 <HTML><HEAD></HEAD><BODY><P>Is that you need??</P><P></P><P><IMG alt="P_271176.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173391_P_271176.png" style="height: 222px; width: 620px;" /></P></BODY></HTML> Mon, 14 Aug 2017 19:22:50 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400443#M424609 ecolomer 2017-08-14T19:22:50Z Re: How to limit the pivot table expressions https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400444#M424610 <HTML><HEAD></HEAD><BODY><P>Thanks Enrique for your quick answer. You are almost right but Vol expression should not be visible at all. Here it is visible as blank. Blank column should not be visible. Whole column should be disappear. I am trying to do this through dimensionality() but it is not working.</P></BODY></HTML> Mon, 14 Aug 2017 19:32:02 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400444#M424610 vipingarg23 2017-08-14T19:32:02Z Re: How to limit the pivot table expressions https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400445#M424611 <HTML><HEAD></HEAD><BODY><P>Try with this expression:</P><P>=if(dimensionality()=0,sum(Vol),null())</P></BODY></HTML> Mon, 14 Aug 2017 19:45:30 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400445#M424611 ecolomer 2017-08-14T19:45:30Z Re: How to limit the pivot table expressions https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400446#M424612 <HTML><HEAD></HEAD><BODY><P>the file qvw, without white() text, and expression with dimensionality()=0</P></BODY></HTML> Mon, 14 Aug 2017 19:47:32 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400446#M424612 ecolomer 2017-08-14T19:47:32Z Re: How to limit the pivot table expressions https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400447#M424613 <HTML><HEAD></HEAD><BODY><P>Perfect....Thanks Enrique for your help..</P></BODY></HTML> Tue, 15 Aug 2017 06:29:39 GMT https://community.qlik.com/t5/QlikView/How-to-limit-the-pivot-table-expressions/m-p/1400447#M424613 vipingarg23 2017-08-15T06:29:39Z