Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
prasanthanr
Partner - Contributor II
Partner - Contributor II

Qlik Sense - P & L Pivot Chart Single Column Background or Font color change

 

Hi Guys,

I am trying to create P & L Pivot chart for my client.

 

P & L Pivot Table.JPG

As per my client requirement, they have requested us to highlight the "only the Actual Sum Column" in "red color" if "Actual sum" is less than a "Budgeted Column".

This is quite an urgent requirement, therefore kindly requesting you all to provide the best solution for me. kindly do the needful ASAP.

Please also find the attachment.

Below I have mentioned the possible tryouts methods but it didn't fulfill my requirement;

* I used an "color by performance", but it didn't workout as per my client requirement. 

Hope you all can understand the question, if not please reply me i can explain you in a better way.

 

Best Regards

Prasanthan

2 Replies
lironbaram
Partner - Master III
Partner - Master III

Hi 

you didn't attach anything , can you attach the sample file 

prasanthanr
Partner - Contributor II
Partner - Contributor II
Author

Hi Liron,

I have attached the screenshot. please go through and provide me the best possible solution.

if you need any more information, please let me know

Best Regards

Prasanthan