Date formula for row of pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

This seems like a great community and I would love some support on this calculation I am trying to do. I have a pivot table that has specific serial numbers for rows and process steps for columns with the measure being the date that process was closed.

I am trying to create a text color expression that highlights certain serial numbers that have not moved in 3+ days from the last complete process.

The current formula is straight forward that is:

if(today()-[Process closed date]>3, red())

The problem I am obviously facing is that this highlights ALL dates that are over 3 days old, which is the majority of dates.

Any thoughts so that the only dates highlighted would be those that have not moved forward in the past 3 days on the LATEST process step?

Thanks for your help!

Re: Date formula for row of pivot table

juraj_misina — Fri, 02 Nov 2018 22:23:37 GMT

Hi,

I assume that the last completed process would have the latest date for that serial number, so I'd try

if(today()-Max([Process closed date])>3, red())

topic Date formula for row of pivot table in QlikView

Date formula for row of pivot table

Re: Date formula for row of pivot table