topic Stacked barchart relative in QlikView https://community.qlik.com/t5/QlikView/Stacked-barchart-relative/m-p/24934#M4120 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to make a stacked barchart where dimension 'year' can be compared divided over dimension 'teams'. Each year should count up to 100% so we can see what the relative size of the teams are compared to total' and how it develops over the years.</P><P></P><P>In my chart&nbsp; the selected years count up to a total 100% as you can see in the picture. Thats not what I want. Can anyone help me? </P><P><IMG alt="Chartproblem.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196304_Chartproblem.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 14 Mar 2018 10:06:53 GMT Anonymous 2018-03-14T10:06:53Z Stacked barchart relative https://community.qlik.com/t5/QlikView/Stacked-barchart-relative/m-p/24934#M4120 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to make a stacked barchart where dimension 'year' can be compared divided over dimension 'teams'. Each year should count up to 100% so we can see what the relative size of the teams are compared to total' and how it develops over the years.</P><P></P><P>In my chart&nbsp; the selected years count up to a total 100% as you can see in the picture. Thats not what I want. Can anyone help me? </P><P><IMG alt="Chartproblem.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196304_Chartproblem.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 14 Mar 2018 10:06:53 GMT https://community.qlik.com/t5/QlikView/Stacked-barchart-relative/m-p/24934#M4120 Anonymous 2018-03-14T10:06:53Z Re: Stacked barchart relative https://community.qlik.com/t5/QlikView/Stacked-barchart-relative/m-p/24935#M4121 <HTML><HEAD></HEAD><BODY><P>Don't use Relative option on the expression tab... rather use an expression like this</P><P></P><P><STRONG>Count(Measure)/Count(TOTAL &lt;jaar&gt; Measure)</STRONG></P></BODY></HTML> Wed, 14 Mar 2018 17:05:20 GMT https://community.qlik.com/t5/QlikView/Stacked-barchart-relative/m-p/24935#M4121 sunny_talwar 2018-03-14T17:05:20Z