topic Horizontal display in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108067#M16926 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>The request is to display a pivot table with horizontal dimension of sales. </P><P>No period selection is needed. </P><P>The challenge is that beside each month, the difference % from previous year has to be displayed for each month.</P><P>The idea of defining 24 expressions is puzzling...</P><P>Any suggestion about the way to approach it?</P><P></P><P><IMG alt="Pivot_Hor..png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213020_Pivot_Hor..png" style="height: 148px; width: 620px;" /></P><P>Thanks!</P></BODY></HTML> Fri, 07 Sep 2018 19:45:02 GMT dafnis14 2018-09-07T19:45:02Z Horizontal display in a pivot table https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108067#M16926 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>The request is to display a pivot table with horizontal dimension of sales. </P><P>No period selection is needed. </P><P>The challenge is that beside each month, the difference % from previous year has to be displayed for each month.</P><P>The idea of defining 24 expressions is puzzling...</P><P>Any suggestion about the way to approach it?</P><P></P><P><IMG alt="Pivot_Hor..png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213020_Pivot_Hor..png" style="height: 148px; width: 620px;" /></P><P>Thanks!</P></BODY></HTML> Fri, 07 Sep 2018 19:45:02 GMT https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108067#M16926 dafnis14 2018-09-07T19:45:02Z Re: Horizontal display in a pivot table https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108068#M16927 <HTML><HEAD></HEAD><BODY><P>You can use a pivot table with Month field on the top and use only two expression 1 for the current month and other for the previous. the only difference the your view and this one would be that you will have Month being divided by 2 columns as Current and previous.</P></BODY></HTML> Fri, 07 Sep 2018 20:07:04 GMT https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108068#M16927 neelamsaroha157 2018-09-07T20:07:04Z Re: Horizontal display in a pivot table https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108069#M16928 <HTML><HEAD></HEAD><BODY><P>Thanks, Neelam!</P><P>It makes sense...</P><P>I'll offer it to the customer.</P></BODY></HTML> Fri, 07 Sep 2018 20:11:30 GMT https://community.qlik.com/t5/QlikView/Horizontal-display-in-a-pivot-table/m-p/108069#M16928 dafnis14 2018-09-07T20:11:30Z