Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

New_Date is less compared to Current selected Old_Date

Hello,

Need an expression for the query.

IF

New_Date is less than 5 Months compared to Current selected Old_Date, it should show N/A

Else

Sum(Sales).

Please help me with expression.

Thanks in Advance.

Labels (2)
1 Reply
Highlighted
Creator II
Creator II

Try this

=if(New_Date<AddMonths(Old_Date,-5),'N/A',Sum(Sales))