topic Stacked Chart in QlikView

Stacked Chart

jagan — Wed, 12 Oct 2011 06:09:10 GMT

Hi,

I need to create a stacked bar chart, with no dimension and with 15 expressions. Is there any way to display the first 5 expressions as one stacked bar, second 5 expressions as one stacked bar and remaining 5 expressions as another stacked bar. When I tried using the Stacked option in Style tab all 15 expressions are converted into one stacked bar. Is there any work around for this.

Regards,

Jagan.

Stacked Chart

vincent_ardiet — Wed, 12 Oct 2011 08:46:25 GMT

Hi Jagan,

May be you can try using two fake dimensions created with the help of valuelist.

First dim : =ValueList('A','B','C')

Second dim : =ValueList('1','2','3','4','5')

In the single expression you will have to do something like this :

if(ValueList('A','B','C')='A',if(ValueList('1','2','3','4','5'),'1',Measure1,if(ValueList('1','2','3','4','5'),'2',Measure2...

I'm not sure that 2 ValueList are possible in the same chart.

Regards,

Vincent

Stacked Chart

jagan — Wed, 12 Oct 2011 11:14:45 GMT

Hi Vincent,

Thanks for your valuable time and help. This works for expressions without AGGR(). Is there any alternate when you use AGGR().

Regards,

Jagan.

Stacked Chart

vincent_ardiet — Wed, 12 Oct 2011 12:27:21 GMT

It doesn't work if you put AGGR() in the IF expression ?

As your chart has no dimension, may be can you define 15 variables containing the result of your different expressions (their definitions must start with an = sign) and use them in your chart expressions?

Regards,

Vincent

Stacked Chart

jagan — Wed, 12 Oct 2011 13:16:58 GMT

Hi Vincent,

Thanks for your great help. This works as I expected, I put all my expressions in variables and used ValueList as you said in Dimension.

Regards,

Jagan.