Conditional colour formatting calculated measure/attribute

[Kirsten]

I would like to apply conditional colour formatting in my (pivot)table for a calculated measure/attribute.

I understood you can do this in "Background Color Expression" under the attribute measure? Though my condition is not straightforward as well as it is for a calculated attribute.  (see attachment for the explanation) How to set up the expression?  And how to create faded colors?

[ArnadoSandoval · Accepted solution]

@Kirsten 

This is the application QVF file

[Kirsten]

Wow I am so impressed @ArnadoSandoval ! It is a very challenging case! Thank you for that.  I need some time to go through all  your steps.  Though my thoughts are also that conditional colour formatting should be a bit more intuitive functionality in Qliksense. In excel with a few clicks it is done. Maybe I'll share those thoughts with the QlikSense team. @Michael_Tarallo  can you look at this topic?

[ArnadoSandoval]

@Kirsten 

I agree, it was not straight forward solution, nevertheless it was possible to do; keep in mind that Qlik is always improving, they are introducing more coloring features on measures, perhaps handling scenarios like yours could become part of those new features to come, I am glad that you escalated this with @Michael_Tarallo  

Regards,

[ArnadoSandoval]

Hi @Kirsten 

To be fair with Qlik, its Master Item Measure has a feature allowing gradient color, but it is not flexible for your requirement, still, it could be helpful in a different scenario.

 

[Kirsten]

@ArnadoSandoval  Ah I see, that one is very helpful. It is very hidden in the dashboard behind a button. At least we don't have to break our brains in all cases! 🙂 Happy weekend!

[Michael_Tarallo]

Hi Guys - I informed the team @Patric_Nordstrom FYI

[Kirsten]

Thanks @Michael_Tarallo   and @Patric_Nordstrom 

[Tony011]

You can use this tool for convert your hec code to decimal to better result