highlight a row in pivot table based on time

[#1]

Is it possible to have Qlik automatically highlight a row in a pivot table 60 minutes before delivery ID run time?

[robertogm]

Not sure if I understood but you can definitely highlight cells in a Pivot table based on the measure value.

In Data on your Measures there is a field called "Background color expression" here you can set conditions to highlight cells.

Use an expression like: if(FIELD='3PM',rgb(176,196,222))

Inside rgb you can set the color code.

Hope this helps.

R

[#3]

I need to base it on time of day.  Like the example about for the 3PM deliveryID I wan to make it change color starting at 2 if there are still items needing worked

[Josh_Good · Accepted solution]

An expression like this will work:

if(Hour = text(time(Now(),'HH')), Red())

However my expression  doesn't account for AM/PM but uses a 24hr clock.  My screen shot below was taken at 2:47 PM local, which is also 14:47.

Hopefully this puts you on the right track.

Josh

Qlik

[#5]

Thank you for your help