Stacked bar graph with specific dimensions

[l_denivelle]

Hi

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 ?

[MK_QSL]

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 !

[Kushal_Chawda · Accepted solution]

this ?

See the attached

[l_denivelle]

Yes !! exactly.

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

Thank you.

[l_denivelle]

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.

[Kushal_Chawda]

How variable is calculated?

[l_denivelle]

Look like this :

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

[Kushal_Chawda]

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

[#9]

In your excel file you have dimensions.

[#10]

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

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