topic Re: Help with Pivot Chart Expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184265#M886379 <HTML><HEAD></HEAD><BODY><P>Would you provide expression</P><P></P><P>OR</P><P></P><P><STRONG>Sum(TOTAL &lt;YourExpression&gt; Sales)</STRONG></P></BODY></HTML> Thu, 15 Sep 2016 06:59:19 GMT Anil_Babu_Samineni 2016-09-15T06:59:19Z Help with Pivot Chart Expression https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184261#M886374 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>I am trying to create a Pivot Chart and calculate the contribution (relative to column) however I can't get it right.</P><P>My Chart looks like:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137435_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>and my expression for Current Year is <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">range</SPAN><SPAN style="font-size: 8pt;">={'CURRENT YEAR'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">dl_descr</SPAN><SPAN style="font-size: 8pt;">)<BR /> </SPAN>How can I create the SOV in a pivot, can only get it to work in straight table</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184261#M886374 2020-11-25T16:16:04Z Re: Help with Pivot Chart Expression https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184262#M886376 <HTML><HEAD></HEAD><BODY><P>Not entirely sure what you are trying to do, would you be able to share a sample?</P></BODY></HTML> Wed, 14 Sep 2016 15:43:16 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184262#M886376 sunny_talwar 2016-09-14T15:43:16Z Re: Help with Pivot Chart Expression https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184263#M886377 <HTML><HEAD></HEAD><BODY><P>What you have tried for SOV for prev year??</P></BODY></HTML> Wed, 14 Sep 2016 16:10:17 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184263#M886377 Anil_Babu_Samineni 2016-09-14T16:10:17Z Re: Help with Pivot Chart Expression https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184264#M886378 <HTML><HEAD></HEAD><BODY><P>This is what I am trying to create:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137508_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>The table is a straight table that I was attempting to get the expression correct so that I could pivot the chart, so prev SOV is the same expression as Current/Previous Prod adv but with relative <IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/137509_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>What I need to do is to calculate the contribution percentage of each row to total of column</P></BODY></HTML> Thu, 15 Sep 2016 04:41:24 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184264#M886378 2016-09-15T04:41:24Z Re: Help with Pivot Chart Expression https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184265#M886379 <HTML><HEAD></HEAD><BODY><P>Would you provide expression</P><P></P><P>OR</P><P></P><P><STRONG>Sum(TOTAL &lt;YourExpression&gt; Sales)</STRONG></P></BODY></HTML> Thu, 15 Sep 2016 06:59:19 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-Chart-Expression/m-p/1184265#M886379 Anil_Babu_Samineni 2016-09-15T06:59:19Z