topic Re: pivot tabel HELP in QlikView https://community.qlik.com/t5/QlikView/pivot-tabel-HELP/m-p/329705#M1167926 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">That is because your Weight1 and Weight fields have one to many relationship with Overall Prespective. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">So to solve the problem you can either average Weight1 and group by Overall Prespective in the script. Or use the following expression. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Level 2 =((<SPAN style="color: #0000ff;">Column</SPAN>(2)/<SPAN style="color: #0000ff;">Column</SPAN>(1)*100)* <SPAN style="color: #0000ff;">Avg</SPAN>(<SPAN style="color: #800000;">Weight1</SPAN>)) </SPAN></P><P><SPAN style="font-size: 10pt;">Level 1 =&nbsp; (<SPAN style="color: #0000ff;">Column</SPAN>(2)/<SPAN style="color: #0000ff;">Column</SPAN>(1)*100<STRONG style=": ; color: #ff8000; text-decoration: underline;">)</STRONG>* <SPAN style="color: #0000ff;">Avg</SPAN> (<SPAN style="color: #800000;">Weight1</SPAN>)* <SPAN style="color: #0000ff;">avg</SPAN> (<SPAN style="color: #800000;">Weight</SPAN>) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 10pt;">However this is based on the assumption that Weight and Weight1&nbsp; can be averaged.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Rahul </SPAN></P></BODY></HTML> Tue, 31 Jul 2012 15:35:42 GMT 2012-07-31T15:35:42Z pivot tabel HELP https://community.qlik.com/t5/QlikView/pivot-tabel-HELP/m-p/329704#M1167925 <HTML><HEAD></HEAD><BODY><P>Hiiiii, i am uploading an application where i have made a pivot table in sheet3, when i fully expand the table values for column(4) and 5 gets populated, but when i changed it into pivot the values get&nbsp; vanished, so i want show the values for that column when my chart is pivot.../</P><P></P><P></P><P></P><P></P><P>So please help</P></BODY></HTML> Tue, 31 Jul 2012 15:20:35 GMT https://community.qlik.com/t5/QlikView/pivot-tabel-HELP/m-p/329704#M1167925 2012-07-31T15:20:35Z Re: pivot tabel HELP https://community.qlik.com/t5/QlikView/pivot-tabel-HELP/m-p/329705#M1167926 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">That is because your Weight1 and Weight fields have one to many relationship with Overall Prespective. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">So to solve the problem you can either average Weight1 and group by Overall Prespective in the script. Or use the following expression. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Level 2 =((<SPAN style="color: #0000ff;">Column</SPAN>(2)/<SPAN style="color: #0000ff;">Column</SPAN>(1)*100)* <SPAN style="color: #0000ff;">Avg</SPAN>(<SPAN style="color: #800000;">Weight1</SPAN>)) </SPAN></P><P><SPAN style="font-size: 10pt;">Level 1 =&nbsp; (<SPAN style="color: #0000ff;">Column</SPAN>(2)/<SPAN style="color: #0000ff;">Column</SPAN>(1)*100<STRONG style=": ; color: #ff8000; text-decoration: underline;">)</STRONG>* <SPAN style="color: #0000ff;">Avg</SPAN> (<SPAN style="color: #800000;">Weight1</SPAN>)* <SPAN style="color: #0000ff;">avg</SPAN> (<SPAN style="color: #800000;">Weight</SPAN>) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 10pt;">However this is based on the assumption that Weight and Weight1&nbsp; can be averaged.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Rahul </SPAN></P></BODY></HTML> Tue, 31 Jul 2012 15:35:42 GMT https://community.qlik.com/t5/QlikView/pivot-tabel-HELP/m-p/329705#M1167926 2012-07-31T15:35:42Z