Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional against row data

Hi

I have a Chart table of Meter Serial Numbers and a last reading date(MAX).

I only want the to display the records that have calculate  Today() - Max[Reading Date] > 2 .

Please see attached

Any help would be wonderful.

2 Replies
Not applicable
Author

use the below expression in ur chart.

if(Today() - Max([Reading Date]) > 2,Metricfield)

Regards,

Kabilan K.

Not applicable
Author

Many Thanks

Worked a charm