topic stacked bar chart 1 expression in QlikView

stacked bar chart 1 expression

Thu, 22 Dec 2011 12:52:09 GMT

Hi,

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

SunilChauhan — Thu, 22 Dec 2011 12:59:52 GMT

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 — Thu, 22 Dec 2011 12:59:55 GMT

Hi,

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

Thu, 22 Dec 2011 13:30:15 GMT

@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 — Thu, 22 Dec 2011 13:32:27 GMT

then create seprate exp for each project

vijay_iitkgp — Thu, 22 Dec 2011 13:50:31 GMT

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