show two stack bars with different expression in qlikview.

[yogitamehta10]

Hi All,

I ‘m looking for a stacked bar graph that will show two bars .  One bar should show my 6 KPI in all the stack of each bar and other bar will show the  targets of all those KPI adjacent to the first bar. My dimension is year and year dimension just have one value.

Any ideas?

TIA

[shanky1907]

You can impose/Merge two Bar charts in such a way that it looks like one..

[yogitamehta10]

I can't do this, otherwise extraction of data is not possible.if I make two charts?any other way

[shanky1907]

Use ValueList function in the Dimension.

as Valuelist(KPI1,KPI2,KPI3....)

In the expression use If else condition as:

If ValueList(KPI1,KPI2,KPI3...)=KPI1,expression of KPI1,

If ValueList(KPI1,KPI2,KPI3...)=KPI12expression of KPI, and so on.

You can take multiple Valulists and add expressions for the same

[vishsaggi]

Can you share some sample data and some kind of sketch or snapshot on a piece of paper, your expected output. ?

[Anonymous]

i am not sure what you mean but if you have 2 expressions you can 'stack' them.

[yogitamehta10]

[yogitamehta10]

I want something like this.

[yogitamehta10]

will it be possible ?

[vishsaggi]

May be try like grouping expression.

Add your two KPIs for Actual and Group them and name them Actual. and same for Target. Then Stack them in Style tab.

Nope sorry i will take it back. It does not work like that. So basically you have two KPI's and you want to combine them as Actual with stacked KPI's. Right?