topic Re: show two stack bars with different expression in qlikview. in QlikView

show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 13:51:39 GMT

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

Re: show two stack bars with different expression in qlikview.

shanky1907 — Thu, 02 Nov 2017 14:08:52 GMT

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

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 14:13:07 GMT

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

Re: show two stack bars with different expression in qlikview.

shanky1907 — Thu, 02 Nov 2017 14:27:44 GMT

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

Re: show two stack bars with different expression in qlikview.

vishsaggi — Thu, 02 Nov 2017 14:38:23 GMT

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

Re: show two stack bars with different expression in qlikview.

Anonymous — Thu, 02 Nov 2017 14:43:39 GMT

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

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 14:54:57 GMT

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 14:55:18 GMT

I want something like this.

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 14:55:59 GMT

will it be possible ?

Re: show two stack bars with different expression in qlikview.

vishsaggi — Thu, 02 Nov 2017 14:59:16 GMT

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?

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 15:02:56 GMT

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

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 15:05:10 GMT

not working

Re: show two stack bars with different expression in qlikview.

vishsaggi — Thu, 02 Nov 2017 15:07:31 GMT

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.

Re: show two stack bars with different expression in qlikview.

yogitamehta10 — Thu, 02 Nov 2017 15:28:04 GMT

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

Re: show two stack bars with different expression in qlikview.

Anonymous — Thu, 02 Nov 2017 16:12:12 GMT

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

Re: show two stack bars with different expression in qlikview.

vishsaggi — Thu, 02 Nov 2017 19:11:34 GMT

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.