topic Sum if / set analysis in QlikView

Sum if / set analysis

Thu, 06 Oct 2011 13:10:58 GMT

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))

Re: Sum if / set analysis

Thu, 06 Oct 2011 14:40:05 GMT

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

Regards,

Kiran.

Re: Sum if / set analysis

Thu, 06 Oct 2011 14:42:33 GMT

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

Re: Sum if / set analysis

Thu, 06 Oct 2011 14:50:44 GMT

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.