topic Re: Pivot table problem in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/1037936#M349694 <HTML><HEAD></HEAD><BODY><P>Can you post a small qlikview document that shows what you're trying to do?</P></BODY></HTML> Wed, 20 Jan 2016 18:29:32 GMT Gysbert_Wassenaar 2016-01-20T18:29:32Z Pivot table problem https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/1037935#M349693 <HTML><HEAD></HEAD><BODY><P>Hi,I need your help..</P><P>I've created a pivot table.</P><P>The table have <SPAN style="font-size: 13.3333px;">dimension </SPAN> "KPI name" that's have a number as key.</P><P>Also have "company name" as the dimension.</P><P>The expression is matched by the KPI key.</P><TABLE><TBODY><TR><TD>KPI_ID</TD><TD>KPI Name</TD></TR><TR><TD>1</TD><TD>PPM Arkal</TD></TR><TR><TD>2</TD><TD>CPM Arkal</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>KPI_ID</TD><TD>CalYear</TD></TR><TR><TD>1</TD><TD>Sum(PRR_Qty)*1000000 / Sum(Sales_Qty)</TD></TR><TR><TD>2</TD><TD>sum(PRR_Qty)</TD></TR></TBODY></TABLE><P>this is the table:</P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112107_1.PNG" style="height: auto;" /></P><P><SPAN style="font-size: 13.3333px;">it is empty, as you can see.. </SPAN></P><P>when I'm choosing a KPI like this:</P><P><IMG alt="2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/112108_2.PNG" style="height: auto;" /></P><P>the table is fine, but only show what i chose:</P><P><IMG alt="3.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/112118_3.PNG" style="height: auto;" /></P><P>but when i'm not choosing the table is empty <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>in the expression, when i write: CalYear it's works but it puts only the string as it is: sum(PRR_Qty)</P><P>when im write: $(=<SPAN style="font-size: 13.3333px;">CalYear ) its working only when im choosing KPI <span class="lia-unicode-emoji" title=":confused_face:">😕</span></SPAN></P><P><SPAN style="font-size: 13.3333px;">why this is happening? your help is appreciated. thank you and have a nice day.</SPAN></P></BODY></HTML> Wed, 20 Jan 2016 13:58:32 GMT https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/1037935#M349693 2016-01-20T13:58:32Z Re: Pivot table problem https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/1037936#M349694 <HTML><HEAD></HEAD><BODY><P>Can you post a small qlikview document that shows what you're trying to do?</P></BODY></HTML> Wed, 20 Jan 2016 18:29:32 GMT https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/1037936#M349694 Gysbert_Wassenaar 2016-01-20T18:29:32Z