topic Re: Stacked bar graph with no dimensions in QlikView

Stacked bar graph with specific dimensions

l_denivelle — Fri, 14 Aug 2015 12:03:32 GMT

I want to create a Stacked bar graph as the one in the attached Excel file.

I have no dimensions, but 4 expressions (variables).

Is - it possible in QlikView ?

Re: Stacked bar graph with specific dimension

MK_QSL — Fri, 14 Aug 2015 12:05:27 GMT

As far as my knowledge says, in QlikView Bar Chart, you can't handle one bar not stacked and 2nd bar stacked !

Wait for others to reply on this !

Re: Stacked bar graph with no dimensions

Kushal_Chawda — Fri, 14 Aug 2015 12:25:08 GMT

this ?

See the attached

Re: Stacked bar graph with no dimensions

l_denivelle — Fri, 14 Aug 2015 12:36:59 GMT

Yes !! exactly.

Let me try it on my application. I'll tell you if I manage to do it.

Thank you.

Re: Stacked bar graph with no dimensions

l_denivelle — Fri, 14 Aug 2015 12:55:37 GMT

The problem is I have variables (whichcontain Set analysis in fact).

How can I put my variables into the "Inline" function ?

Data:

LOAD * Inline [

Dim, Value, Flag

Mt Demandé,$(MyVariable1),Mt Demandé

Mt eng,0,Mt Demandé

init refus,0,Mt Demandé

Mt eng compl,0,Mt Demandé

Mt Demandé,0,Eng total

Mt eng,$(MyVariable2),Eng total

init refus,$(MyVariable3),Eng total

Mt eng compl,$(MyVariable4),Eng total ];

This doesn't work.

Re: Stacked bar graph with no dimensions

Kushal_Chawda — Fri, 14 Aug 2015 13:25:40 GMT

How variable is calculated?

Re: Stacked bar graph with no dimensions

l_denivelle — Fri, 14 Aug 2015 13:58:02 GMT

Look like this :

LET MyVariable1 = 'Count({<[Type de date]={"Engagement init"}, [Année] = {"$(=(Max([Année])))"} >} DISTINCT [Code module])';

Re: Stacked bar graph with no dimensions

Kushal_Chawda — Fri, 14 Aug 2015 14:11:45 GMT

In expression of chart you can just copy the expression of variable

Re: Stacked bar graph with no dimensions

Fri, 14 Aug 2015 14:19:48 GMT

In your excel file you have dimensions.

Re: Stacked bar graph with no dimensions

Fri, 14 Aug 2015 14:22:31 GMT

use concat function to sum up the values with Rangesum function like below to construct the expressions:

=$(= 'Rangesum('&concat(distinct Value , ',' ) &')' )

Re: Stacked bar graph with no dimensions

l_denivelle — Fri, 14 Aug 2015 14:44:03 GMT

I didn't manage to make it work

Re: Stacked bar graph with specific dimensions

l_denivelle — Fri, 14 Aug 2015 14:46:03 GMT

I changed the title

I didn't really know what to put.

Re: Stacked bar graph with specific dimensions

Fri, 14 Aug 2015 15:40:10 GMT

Please post qvw with your sample data?

Re: Stacked bar graph with specific dimensions

Kushal_Chawda — Fri, 14 Aug 2015 15:55:58 GMT

Without looking into your data it will be difficult to answer your query. Provide some sample data