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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding AR Aging Days Expression

Hai Paul,

Please refer the below expression which I'm trying to get the Over 90 days only in the AR report.

= class(

if(NUM( ASONDATE- DocDate) > 90, 90 + 1, NUM(ASONDATE - DocDate)

)

, 90, 'Days', 180)

But the value return 0 to 90 and over 90.Please help me the modify the above expression to remove 0 to 90 days.

Thanks in advance

0 Replies