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

[yogitamehta10]

but what  about values will it show two values on each bar then ( for two KPIs)

[yogitamehta10]

not working

[vishsaggi]

It does not work like that. As Sashank suggested you might have to use Pick() Dimensions or ValueList function. IF you can share some sample data will be easy to work on. Can you create some sample data and the expressions you are trying that would be great.

[yogitamehta10]

year	KPI1	KPI 2	KPI1 Targets	KPI 2 Targets
2017	23	34	35	23
2017	24	23	35	35
2017	25	23	45	78
2017	25	27	56	78
2017	26	23	45	45
2017	27	29	45	34
2017	28	30	45	34

[Anonymous]

try to group KPI1 with KPI2 and KPI1Target with KPI2 Target from the expression window and try again the style as i mentioned in the screenshot

[vishsaggi]

I am not sure if that is possible. But this is the best i could do but may be not what you looking for. However, might be swuehl‌ can put some light on this.

Hey Stefan, any ideas on how to stack the KPIs and Targets as stacked bars rather than individual bars. Shown in the attached.