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:
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
- 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.
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
Resource v1.1.qvf 240.0 K