Set Analysis , If or Multiplication

[#1]

Can any body suggest me , which one of the expressions will be faster on huge data for QlikView 8.5

1. sum(Sales*Flag)

2. Sum(if(Flag,Sales)

3.Sum( {$ <Flag = {1}>} Sales)

I went through the forum & Blogs in qlikview, but I am really confused.

Any suggestions will be appreciated.

[#2]

Hi,

Have you seen the post http://community.qlik.com/forums/p/17188/67225.aspx#67225 where John Witherspoon made some test. .

regards

jj

[#3]

I saw that post , I found it really confusing. That is why I asked this question again.

Is it possible to look at my expressions and say which could be faster?

[johnw]

Of the options you presented, I recommend #3. You might also consider:

4. sum(FlaggedSales) // Establish this field in the script - if(Flag,Sales) as FlaggedSales.

I suspect that's the fastest option of all, but haven't done any testing to make certain. You could test using your own data and find out for yourself.