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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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