Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-11-07 06:07 AM

Condition Formatting for Pivot Table

Hi,

Can we do condition formatting for Pivot table in Qlik Sense?

Example if the value <=3% show that value or background as Red else Green

Labels (1)
Labels
879 Views
0 Likes
4 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-11-07 06:44 AM

Yes, please enable the option called expression by color

If(Value < 0.3, Red(), Green())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
792 Views
0 Likes
Anonymous
Not applicable
‎2017-11-07 08:09 AM
Author

In response to Anil_Babu_Samineni

Where to enable? Should I enter the condition in "Text color expression"?

792 Views
Anonymous
Not applicable
‎2017-11-07 08:25 AM
Author

In response to Anonymous

Is it a Chart or just a Table?

792 Views
0 Likes
Anonymous
Not applicable
‎2017-11-07 08:26 AM
Author

In response to Anonymous

Ajuda.PNG

792 Views
0 Likes