Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

1 Solution

Accepted Solutions
OmarBenSalem

Hi again Agrim,

I'd propose sthing like the app attached.

Please see it and and tell me that if this work around is doing the trick

View solution in original post

7 Replies
rahulpawarb
Specialist III
Specialist III

Hello Agrim,

I believe that you have already gone through below settings:

- Locate expression and change the layout to bars from expressions (in stacked bar chart)

Please correct me if I am wrong.

Regards!

Rahul

xyz1
Creator III
Creator III
Author

.

OmarBenSalem

Hi agrim,

It's actually not possible, the only way is to add all the actual values in a same expression and do it again with the present:

Capture.PNG

With that being said, with Qlik Sense 3.2 + , It's possible to create a master measure and affect a color to it.

BUT, the qlik team should, as a next step, enable the combination and call of more thant a master measure

Let me explain the utility of doing so in your case:

Actual is composed of : sum([RUN])+Sum(Enable)

With the current capabilities of Qlik Sense, we can

create :

- a master measure: Actual Run = Sum(RUN) and color it as Blue

- a master measure: Actual Enable= Sum(Enable) and color it as Red

Now, if we could combine 2 master measures:

Our measure would be Actual Run + Actual Enable in the same measure, and each master measure will have its color in the same new measure.

We can proceed the same way with the present measures, create 2 master measures, combine them in the same measure (each will have its own color) and with that, we could have only 2 measures and they will be stacked(each is an association of 2 masters measures)

Please mto‌, let your team think about such a feature; it will open such new doors.

Thank you,

rahulpawarb
Specialist III
Specialist III

Hello Agrim,

You can opt for Grouped under presentation settings or Alternative Measures option.

Hope this will help.

Regards!

Rahul

xyz1
Creator III
Creator III
Author

.

shraddha_g
Partner - Master III
Partner - Master III

In Apperance Section, have you chosen Stacked Bar option?

OmarBenSalem

Hi again Agrim,

I'd propose sthing like the app attached.

Please see it and and tell me that if this work around is doing the trick