topic Re: Merge two expressions? in QlikView

Merge two expressions?

Akina0929 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Merge two expressions?

vishsaggi — Wed, 26 Jul 2017 14:47:56 GMT

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

Re: Merge two expressions?

Akina0929 — Wed, 26 Jul 2017 15:04:47 GMT

Hi Nagaraju,

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

Re: Merge two expressions?

vishsaggi — Wed, 26 Jul 2017 15:23:35 GMT

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 :

Re: Merge two expressions?

Venkatchoudary — Wed, 26 Jul 2017 15:27:58 GMT

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

Re: Merge two expressions?

Akina0929 — Wed, 26 Jul 2017 15:28:38 GMT

Hi Nagarju,

I want like attached Image

Re: Merge two expressions?

vishsaggi — Wed, 26 Jul 2017 15:32:52 GMT

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.

Re: Merge two expressions?

Anil_Babu_Samineni — Wed, 26 Jul 2017 15:39:04 GMT

May be this?

Re: Merge two expressions?

effinty2112 — Wed, 26 Jul 2017 16:06:21 GMT

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

Re: Merge two expressions?

vishsaggi — Wed, 26 Jul 2017 16:15:03 GMT

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

Re: Merge two expressions?

effinty2112 — Wed, 26 Jul 2017 18:12:09 GMT

Hi,

Just add your other dimension to the chart as the first dim: