stacked bar chart 1 expression

[#1]

Hi,

Does anyone have an idea how create the following chart in QlikView?

[SunilChauhan]

take a bar chart

projects in dimensions

and in expression sum(peak sales)

and in style-> select stack radio butto

select vertical for y axis in axes

hope this heelps

[vijay_iitkgp · Accepted solution]

Hi,

You can create one dummy calulated dimension ='Project' and the checked the stack option in style.

[#4]

@Sunil If you have only 1 expression and 1 dimension you can't select the stacked radio button.

The creation of the dummy dimension also doesn't work. Or I do something wrong...

[SunilChauhan]

then create seprate exp  for each project

[vijay_iitkgp]

It is working. Create calculated Dimension ='Project' , and then add your project as 2nd dimension and check stack option. it will work.