Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
l_denivelle
Creator
Creator

Stacked bar graph with specific dimensions

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 ?

1 Solution

Accepted Solutions
Kushal_Chawda

this ?

See the attached

View solution in original post

13 Replies
MK_QSL
MVP
MVP

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

this ?

See the attached

l_denivelle
Creator
Creator
Author

Yes !! exactly.

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

Thank you.

l_denivelle
Creator
Creator
Author

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
Creator
Creator
Author

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

Not applicable

In your excel file you have dimensions.

Not applicable

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

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