# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
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:

2) in ur bar chart:

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

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:

3 Replies
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:

2) in ur bar chart:

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

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:

Honored Contributor III

## Re: Stack Bar in Qlik sense

Thanks perfect

Honored Contributor III

## Re: Stack Bar in Qlik sense

Will  try and mark correct!!

Thanks

Vikas