Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum if / set analysis

Not sure if this is correct. Could someone look at it and let me know?

(the underlining idea is: I've tried to convert but o a set analysis with no luck becasue of the InYearToDate function)

tks!

Sum (if (ACTUALCLOSE<= ReportToDateLastYear and ACTUALCLOSE>=ReportFromDateLastYear and InYearToDate (DATEFROM, yearend(ReportDate,0,8), -1, 😎 AND OPPORTUNITY.STATUS='Closed - Won', ACTUALAMOUNT))
1 Solution

Accepted Solutions
Not applicable
Author

Yes, <= can be used in if condition or set analysis. But if condition consumes more memory compared to set. If you can have your expression calculated at the script level, you can directly use that in set anlaysis.

Let me know you face any problem with the expression.

Regards,

Kiran.

View solution in original post

3 Replies
Not applicable
Author

Your expression by syntax is right. Better way from memory prespective is to have InYearToDate inside script and use set analysis.

Regards,

Kiran.

Not applicable
Author

does this mean i can use the "<=" operator in the expression without having to use it in a set analysis?

Not applicable
Author

Yes, <= can be used in if condition or set analysis. But if condition consumes more memory compared to set. If you can have your expression calculated at the script level, you can directly use that in set anlaysis.

Let me know you face any problem with the expression.

Regards,

Kiran.

View solution in original post