Discussion board where members can get started with Qlik Sense.
Is it possible to have Qlik automatically highlight a row in a pivot table 60 minutes before delivery ID run time?
Go to 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.
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.
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
Thank you for your help