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: 
jduluc12
Creator
Creator

Replace "IF" with set analysis

Hi,

Is there any way to remove "if" statement in this expression and use everything in set analysis?

=sum({<[Type]={'AR'}, [Date1]={'<=$(=date(fDate))'}>}if( ([Date2]>date(fDate) or IsNull([Date2])) and  date(fDate)-[Date3] < 100,[Amt],0)

Thanks,

2 Replies
Chanty4u
MVP
MVP

put this in script as a flag

if( ([Date2]>date(fDate) or IsNull([Date2]))   as Flag


jduluc12
Creator
Creator
Author

i have no access to the script.