Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten
Creator II
Creator II

Conditional colour formatting calculated measure/attribute

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?

 

Labels (1)
16 Replies
ArnadoSandoval
Specialist II
Specialist II

@Kirsten 

This is the application QVF file

 

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Kirsten
Creator II
Creator II
Author

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
Specialist II
Specialist II

@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,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
ArnadoSandoval
Specialist II
Specialist II

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.

07.Table_Colors-07.jpg07.Table_Colors-08.jpg 

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Kirsten
Creator II
Creator II
Author

@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
Employee
Employee

Hi Guys - I informed the team @Patric_Nordstrom FYI

Regards,
Mike Tarallo
Qlik
Kirsten
Creator II
Creator II
Author

Thanks @Michael_Tarallo   and @Patric_Nordstrom