Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.