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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksairam89
Creator
Creator

Color Expression Based Range of values pivot table

Hi,

Iam trying to put background color based on the range of Numbers with blue color i am not able to get the color for the range of numbers

Iam using pivot table

For Rows = Hours
Column = Weekday and date

Measure = sum(calls)

Used Expression in background color expression:

ARGB(Sum(calls)/Max(TOTAL (calls),weekday,hour)*256,68,119,170)

So can you help me out!

0 Replies