Merge two expressions?

[Akina0929]

Hi ,

I have three expression I want to show three expressions in Bar chart like ..

I want to show two Expressions in one Bar and Different colors .

Third want to show beside that stacked Bar.

[vishsaggi]

Can you explain a little with some sample data and expected output?

[Akina0929]

Hi Nagaraju,

      I have three expression, I want to prepare stacked bar for two expressions.

[vishsaggi]

I doubt it is possible. May be you can try like have two expressions as Stacked bar and third expression as a Line using Combo Chart. Will this work? Something like :

[Venkatchoudary]

I don't think we have that functionality in QlikView .
We have only one selection 'Grouped' or 'stacked'

[Akina0929]

Hi Nagarju,

I want like attached Image

[vishsaggi]

Yes, i understand what you want, but not sure if that is possible. I am not sure. Hence gave you a work around. May be if someone else can come up with any macro options.

[Anil_Babu_Samineni]

May be this?

[effinty2112]

Hi Anji,

With the calculated dimension =ValueList('A','B') and the three expressions shown you can create this stacked bar chart. you can give the expressions and the dimensions meaningful labels.

Regards

Andrew

[vishsaggi]

What if we have two dimensions or a month as a dimension?