Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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