topic Pivot Table&gt;&gt;How to conditionally show dimension? in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742985#M535681 <HTML><HEAD></HEAD><BODY><P>Hi Qlikview Experts!</P><P></P><P>How do I hide a dimension for a given expression?&nbsp; My pivot table has the below dimensions and expressions. For a given expression, I want to hide dimensions.&nbsp; For example, for the dimension, "Ben Income ($)", I only want to show "Ben Revenues".</P><P></P><P>Dimensions:</P><OL><LI>ProductionCategory</LI><LI>MonthYear</LI></OL><P></P><P>Expressions:</P><OL><LI>Net Production ($)</LI><LI>Ben Income ($)</LI></OL><P>H<IMG alt="Qlikview Pivot.png" class="image-1 jive-image" src="/legacyfs/online/74706_Qlikview Pivot.png" style="height: 330px; width: 620px;" /></P></BODY></HTML> Tue, 06 Jan 2015 17:26:58 GMT 2015-01-06T17:26:58Z Pivot Table>>How to conditionally show dimension? https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742985#M535681 <HTML><HEAD></HEAD><BODY><P>Hi Qlikview Experts!</P><P></P><P>How do I hide a dimension for a given expression?&nbsp; My pivot table has the below dimensions and expressions. For a given expression, I want to hide dimensions.&nbsp; For example, for the dimension, "Ben Income ($)", I only want to show "Ben Revenues".</P><P></P><P>Dimensions:</P><OL><LI>ProductionCategory</LI><LI>MonthYear</LI></OL><P></P><P>Expressions:</P><OL><LI>Net Production ($)</LI><LI>Ben Income ($)</LI></OL><P>H<IMG alt="Qlikview Pivot.png" class="image-1 jive-image" src="/legacyfs/online/74706_Qlikview Pivot.png" style="height: 330px; width: 620px;" /></P></BODY></HTML> Tue, 06 Jan 2015 17:26:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742985#M535681 2015-01-06T17:26:58Z Re: Pivot Table>>How to conditionally show dimension? https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742986#M535682 <HTML><HEAD></HEAD><BODY><P>Is that you need?</P><P></P><P>Can you upload an example with data?</P><P></P><P><IMG __jive_id="74714" alt="p05.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74714_p05.png" style="height: 407px; width: 620px;" /></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/74715_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 06 Jan 2015 18:39:52 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742986#M535682 ecolomer 2015-01-06T18:39:52Z Re: Pivot Table>>How to conditionally show dimension? https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742987#M535683 <HTML><HEAD></HEAD><BODY><P>Yes, I think that's what I want to do.&nbsp; I'd have to see the code.&nbsp; </P><P></P><P>Attached is my code and data.&nbsp; </P></BODY></HTML> Tue, 06 Jan 2015 18:43:53 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742987#M535683 2015-01-06T18:43:53Z Re: Pivot Table>>How to conditionally show dimension? https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742988#M535684 <HTML><HEAD></HEAD><BODY><P>Can you post your QVW?</P></BODY></HTML> Tue, 06 Jan 2015 19:03:20 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742988#M535684 2015-01-06T19:03:20Z Re: Pivot Table>>How to conditionally show dimension? https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742989#M535686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>after studying the data, I think the best solution is to create a load script sencilllas clusters of concepts</P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74717_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 06 Jan 2015 19:28:23 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-gt-gt-How-to-conditionally-show-dimension/m-p/742989#M535686 ecolomer 2015-01-06T19:28:23Z