topic Re: Can I conditionally hide expression columns in a Pivot Table? in QlikView https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345361#M576665 <HTML><HEAD></HEAD><BODY><P>Little trick will do in qv10.</P><P></P><P></P><P><A class="jive-link-external-small" href="http://community.qlik.com/servlet/JiveServlet/download/2004-35129-148327-22275/Pivot+Table+Expreesion+selector.qvw">http://community.qlik.com/servlet/JiveServlet/download/148327-22275/Pivot%20Table%20Expreesion%20selector.qvw</A></P><P></P><P></P><P>Dwonload the above file.</P><P></P><P></P><P>Regards </P><P>PHANI</P></BODY></HTML> Thu, 10 May 2012 00:48:16 GMT phaneendra_kunc 2012-05-10T00:48:16Z Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345359#M576663 <HTML><HEAD></HEAD><BODY><P>I see how to do it with a straight table but can't find a way to hide expression columns in a Pivot Table?</P><P></P><P>Thanks for any help!!</P></BODY></HTML> Wed, 09 May 2012 21:18:52 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345359#M576663 2012-05-09T21:18:52Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345360#M576664 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>It's only possible in QV 11. </P><P>In the expressions tab you can set the condition to hide/ show expressions. </P><P></P><P>You can check this behavior in the attachment. ( using QV11) </P><P></P><P>Hope this helps, </P><P></P><P>Erich</P></BODY></HTML> Wed, 09 May 2012 22:45:25 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345360#M576664 erichshiino 2012-05-09T22:45:25Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345361#M576665 <HTML><HEAD></HEAD><BODY><P>Little trick will do in qv10.</P><P></P><P></P><P><A class="jive-link-external-small" href="http://community.qlik.com/servlet/JiveServlet/download/2004-35129-148327-22275/Pivot+Table+Expreesion+selector.qvw">http://community.qlik.com/servlet/JiveServlet/download/148327-22275/Pivot%20Table%20Expreesion%20selector.qvw</A></P><P></P><P></P><P>Dwonload the above file.</P><P></P><P></P><P>Regards </P><P>PHANI</P></BODY></HTML> Thu, 10 May 2012 00:48:16 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345361#M576665 phaneendra_kunc 2012-05-10T00:48:16Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345362#M576666 <HTML><HEAD></HEAD><BODY><P>Wow! Very clever! Thank you!</P></BODY></HTML> Thu, 10 May 2012 12:02:26 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345362#M576666 2012-05-10T12:02:26Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345363#M576667 <HTML><HEAD></HEAD><BODY><P>Thank you… we’ll be moving to QV 11 soon… in the meantime I do know I can make different versions of the whole table and hide/show the tables conditionally…</P></BODY></HTML> Thu, 10 May 2012 12:04:50 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345363#M576667 2012-05-10T12:04:50Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345364#M576668 <HTML><HEAD></HEAD><BODY><P>Nice example, but it's based on variable.</P><P></P><P>Is it possible to conditionally show/hide expression column based on the expand or collapse column?</P><P>i tried with dimentionality, but i have a total row on top.</P><P></P><P>Any idea?</P></BODY></HTML> Thu, 08 Nov 2012 14:00:56 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345364#M576668 2012-11-08T14:00:56Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345365#M576669 <HTML><HEAD></HEAD><BODY><P>For my purposes the problem was solved perfectly in version 11! You can define conditions for showing the dimensions and expressions… very cool ☺</P></BODY></HTML> Thu, 08 Nov 2012 14:06:28 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345365#M576669 2012-11-08T14:06:28Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345366#M576670 <HTML><HEAD></HEAD><BODY><P>Yes Karen. </P><P>But i'm trying to show says - Expression 1 when certain dimensions are expanded.</P><P>and expression 1 should be hidden when the dimension is in collapse.</P></BODY></HTML> Thu, 08 Nov 2012 14:09:17 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345366#M576670 2012-11-08T14:09:17Z Re: Can I conditionally hide expression columns in a Pivot Table? https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345367#M576671 <HTML><HEAD></HEAD><BODY><P>I see… yeah, that’s a little trickier… I don’t have an answer for that…</P></BODY></HTML> Thu, 08 Nov 2012 14:14:16 GMT https://community.qlik.com/t5/QlikView/Can-I-conditionally-hide-expression-columns-in-a-Pivot-Table/m-p/345367#M576671 2012-11-08T14:14:16Z