Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhargavikn
Contributor III
Contributor III

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
bharathadde
Creator II
Creator II

Try this

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