topic Re: Pivot table expression in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107510#M904934 <HTML><HEAD></HEAD><BODY><P>Can you post some sample data ?</P></BODY></HTML> Mon, 27 Jun 2016 06:57:36 GMT varshavig12 2016-06-27T06:57:36Z Pivot table expression https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107506#M904930 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="129072" alt="recqty.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129072_recqty.png" style="height: 104px; width: 620px;" /></P><P>Hi</P><P></P><P>I have attached the screen shot in this case i have only recqty(Final column) for only 2 distributor which i have marked both has recqty0.68 others</P><P>has no recqty but i am geting all the values are 0.68.</P><P></P><P>is there any wrong with data modal?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107506#M904930 stephenedberkg 2020-11-25T16:16:04Z Re: Pivot table expression https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107507#M904931 <HTML><HEAD></HEAD><BODY><P>I'm not sure,</P><P>But you can try this:</P><P></P><P>aggr(sum(recqty),Distributor)</P></BODY></HTML> Fri, 24 Jun 2016 09:42:23 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107507#M904931 varshavig12 2016-06-24T09:42:23Z Re: Pivot table expression https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107508#M904932 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/people/varshavig12">varshavig12</A></P><P></P><P>Already i tried but not working</P></BODY></HTML> Fri, 24 Jun 2016 15:05:10 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107508#M904932 stephenedberkg 2016-06-24T15:05:10Z Re: Pivot table expression https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107509#M904933 <HTML><HEAD></HEAD><BODY><P>Stephen,</P><P></P><P>You're going to need to supply additional information.&nbsp; </P><P></P><P>What dimensions and expressions are you using?&nbsp; </P><P>What relationship do the dimensions and expressions have?&nbsp; </P><P>Are they coming from a single table or multiple tables?</P><P></P><P>Maybe you can post an example of your data?</P><P></P><P>Good luck </P><P>Oscar</P></BODY></HTML> Sat, 25 Jun 2016 07:32:30 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107509#M904933 oscar_ortiz 2016-06-25T07:32:30Z Re: Pivot table expression https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107510#M904934 <HTML><HEAD></HEAD><BODY><P>Can you post some sample data ?</P></BODY></HTML> Mon, 27 Jun 2016 06:57:36 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expression/m-p/1107510#M904934 varshavig12 2016-06-27T06:57:36Z