Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

MVP
MVP

Stacked Chart

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.

Tags (3)
1 Solution

Accepted Solutions
vincent_ardiet
Contributor III

Stacked Chart

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

4 Replies
vincent_ardiet
Contributor III

Stacked Chart

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

MVP
MVP

Stacked Chart

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.

vincent_ardiet
Contributor III

Stacked Chart

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

MVP
MVP

Stacked Chart

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.

Community Browser