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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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