Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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
Kush
MVP
MVP

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 !

Kush
MVP
MVP

this ?

See the attached

View solution in original post

l_denivelle
Creator
Creator

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

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.

Kush
MVP
MVP

How variable is calculated?

l_denivelle
Creator
Creator

Look like this :

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

Kush
MVP
MVP

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