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: 
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.