topic Re: Stacked Pivot Chart showing relative values in QlikView https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137309#M373131 <HTML><HEAD></HEAD><BODY><P>Thanks - works</P></BODY></HTML> Fri, 05 Aug 2016 11:21:51 GMT claude_jakob 2016-08-05T11:21:51Z Stacked Pivot Chart showing relative values https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137307#M373129 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>I am struggling with Qlikview in creating a pivot chart/table showing relative values. I want to show %Sales per year and for each year the %numbers need to add up to 100% (Excel Pivot Table.png). I have attached the correct example as done in Excel pivot table. Trying this in QV the expression seems incomplete (QV pivot chart.png).</P><P>When using absolute numbers the stacked chart looks fine. When selecting "Relative" in the Expression tab %-figures are calculated but the values of the whole chart adds up to 100% - and not as needed.</P><P></P><P>I have attached Excel file (with data) and a qvw app for reference. Thanks for any thoughts</P><P>Claude</P></BODY></HTML> Fri, 05 Aug 2016 10:34:20 GMT https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137307#M373129 claude_jakob 2016-08-05T10:34:20Z Re: Stacked Pivot Chart showing relative values https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137308#M373130 <HTML><HEAD></HEAD><BODY><P>Disable the Relative option and use this expression: sum(Sales)/sum(total &lt;Year&gt; Sales)</P></BODY></HTML> Fri, 05 Aug 2016 11:20:08 GMT https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137308#M373130 Gysbert_Wassenaar 2016-08-05T11:20:08Z Re: Stacked Pivot Chart showing relative values https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137309#M373131 <HTML><HEAD></HEAD><BODY><P>Thanks - works</P></BODY></HTML> Fri, 05 Aug 2016 11:21:51 GMT https://community.qlik.com/t5/QlikView/Stacked-Pivot-Chart-showing-relative-values/m-p/1137309#M373131 claude_jakob 2016-08-05T11:21:51Z