Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

Stack Bar in Qlik sense

Hi all,

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

Thanks

Vikas

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Stack Bar in Qlik sense

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

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 :

Capture.PNG

result:

Capture.PNG

3 Replies
OmarBenSalem
Esteemed Contributor

Re: Stack Bar in Qlik sense

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

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 :

Capture.PNG

result:

Capture.PNG

vikasmahajan
Honored Contributor III

Re: Stack Bar in Qlik sense

Thanks perfect

vikasmahajan
Honored Contributor III

Re: Stack Bar in Qlik sense

Will  try and mark correct!!

Thanks

Vikas

Community Browser