Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

viveksairam89
Contributor

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!

Community Browser