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:
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

this ?

See the attached

13 Replies
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 !

this ?

See the attached

Creator
Author

Yes !! exactly.

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

Thank you.

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.

How variable is calculated?

Creator
Author

Look like this :

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

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 , ',' ) &')' )

Community Browser