Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

highlight a row in pivot table based on time

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

1 Solution

Accepted Solutions
Employee
Employee

Re: highlight a row in pivot table based on time

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

2016-11-03 14_47_08-.png

4 Replies
robertogm
New Contributor II

Re: highlight a row in pivot table based on time

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

Not applicable

Re: highlight a row in pivot table based on time

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

Employee
Employee

Re: highlight a row in pivot table based on time

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

2016-11-03 14_47_08-.png

Not applicable

Re: highlight a row in pivot table based on time

Thank you for your help