Stack Bar in Qlik sense

[vikasmahajan]

Hi all,

Please find attached excel sheet  I wanted to create a stack bar like attached in excel in Qlik Sense .

Thanks

Vikas

[OmarBenSalem · Accepted solution]

1) create a master dimension for your field company, and assigne the colors u want to its values:

2) in ur bar chart:

dim 1 = =ValueList('Growth','Sales LY','Sales CY')

dim2= your created master measure

as a measure :

if(ValueList('Growth','Sales LY','Sales CY')='Growth', num(Sum(Grow),'# ##0,00%'),

if(ValueList('Growth','Sales LY','Sales CY')='Sales LY', sum([Sale LY]),

if(ValueList('Growth','Sales LY','Sales CY')='Sales CY',sum([Sale CY]))))

under aspect :

result:

[vikasmahajan]

Thanks perfect

[vikasmahajan]

Will  try and mark correct!!

Thanks

Vikas