topic Re: Hide expressions in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719217#M1070130 <HTML><HEAD></HEAD><BODY><P>Try Expression Grouping if possible </P></BODY></HTML> Thu, 21 Aug 2014 06:12:10 GMT sujeetsingh 2014-08-21T06:12:10Z Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719216#M1070128 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I want to create a pivot table and show certain expressions only under certain group. </P><P>For eg : In the attached file, I want to show Enterprise Infra Support, Personal Support etc under Fixed and Avamr, Projects under variable. I have used IF condition, still it is showing up under both. </P><P>Please advise. </P></BODY></HTML> Thu, 21 Aug 2014 06:09:18 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719216#M1070128 2014-08-21T06:09:18Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719217#M1070130 <HTML><HEAD></HEAD><BODY><P>Try Expression Grouping if possible </P></BODY></HTML> Thu, 21 Aug 2014 06:12:10 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719217#M1070130 sujeetsingh 2014-08-21T06:12:10Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719218#M1070132 <HTML><HEAD></HEAD><BODY><P>Can u pls elaborate</P></BODY></HTML> Thu, 21 Aug 2014 06:22:29 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719218#M1070132 2014-08-21T06:22:29Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719219#M1070133 <HTML><HEAD></HEAD><BODY><P>Hi Paramita Sahu,</P><P></P><P>Did you get a work-around to this question? I am having exactly the same requirement!</P><P></P><P>Thank you in advance,</P><P></P><P>/Yolanda</P></BODY></HTML> Wed, 01 Oct 2014 08:55:13 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719219#M1070133 2014-10-01T08:55:13Z Re: Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719220#M1070135 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>To hide expression just give wrong calculated condition in Conditional value.</P><P></P><P>Have a look at attached image.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 01 Oct 2014 08:59:44 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719220#M1070135 ashfaq_haseeb 2014-10-01T08:59:44Z Re: Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719221#M1070137 <HTML><HEAD></HEAD><BODY><P>Thank you Mohammed,</P><P></P><P>But this will hide the expression for all the dimensions. What I need is to hide the expresion for certain dimensions (I want some columns to appear only for a specific value of one of the dimesions).</P><P></P><P>BR,</P><P></P><P>/Yolanda</P></BODY></HTML> Wed, 01 Oct 2014 09:04:51 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719221#M1070137 2014-10-01T09:04:51Z Re: Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719222#M1070139 <HTML><HEAD></HEAD><BODY><P>Can you share sample application with Expected output</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 01 Oct 2014 09:08:21 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719222#M1070139 ashfaq_haseeb 2014-10-01T09:08:21Z Re: Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719223#M1070140 <HTML><HEAD></HEAD><BODY><P>Something like:</P><P><IMG alt="table_example.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68073_table_example.png" style="width: 620px; height: 205px;" /></P></BODY></HTML> Wed, 01 Oct 2014 09:20:38 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719223#M1070140 2014-10-01T09:20:38Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719224#M1070142 <HTML><HEAD></HEAD><BODY><P>why u are not uncheck expression in expression tab.</P></BODY></HTML> Wed, 01 Oct 2014 10:35:24 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719224#M1070142 deepakqlikview_123 2014-10-01T10:35:24Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719225#M1070144 <HTML><HEAD></HEAD><BODY><P>Hi Yolanda,</P><P></P><P>Have you solved the problem yet?</P><P>As I'm facing the same problem of hiding columns in pivot table, Thanks!</P><P></P><P>Best Regards,</P><P>Crystal</P></BODY></HTML> Tue, 07 Oct 2014 04:47:32 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719225#M1070144 2014-10-07T04:47:32Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719226#M1070145 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As a work-around I added the "Extra Expression" as a calculated dimension.</P><P></P><P>BR,</P><P></P><P>/Yolanda</P></BODY></HTML> Tue, 07 Oct 2014 05:44:27 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719226#M1070145 2014-10-07T05:44:27Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719227#M1070147 <HTML><HEAD></HEAD><BODY><P>Hi Yolanda,</P><P></P><P>Could you kindly let me know how you are able to make it into calcualted dimension? When I put in group function in the pivot table like sum, it will become an 'error in calcualted dimension'.<BR />Also, in your case, how do u prevent "Expression 1","Expression 2","Expression 3" as sub level under "Extra Expression"?<BR />Thanks!</P><P></P><P>Best Regards,</P><P>Crystal</P></BODY></HTML> Tue, 07 Oct 2014 06:52:38 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719227#M1070147 2014-10-07T06:52:38Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719228#M1070148 <HTML><HEAD></HEAD><BODY><P>Hi Crystal,</P><P></P><P>I recommend you to read about aggr functionality. For example take a look at this post: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr">http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr</A></P><P></P><P>In my work-around I defined the "Extra Expression" as aggr(expression,dim1,dim2) and I placed it before dim3.</P><P></P><P>I hope this helps you!</P><P></P><P>Good luck!</P><P></P><P>/Yolanda</P></BODY></HTML> Tue, 07 Oct 2014 07:01:43 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719228#M1070148 2014-10-07T07:01:43Z Re: Hide expressions in Pivot table https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719229#M1070149 <HTML><HEAD></HEAD><BODY><P><BR />Thanks very much, Yolanda!</P></BODY></HTML> Sun, 12 Oct 2014 10:31:26 GMT https://community.qlik.com/t5/QlikView/Hide-expressions-in-Pivot-table/m-p/719229#M1070149 2014-10-12T10:31:26Z