topic Set Analysis , If or Multiplication in QlikView

Set Analysis , If or Multiplication

Tue, 02 Mar 2010 22:30:04 GMT

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.

Set Analysis , If or Multiplication

Tue, 02 Mar 2010 22:55:56 GMT

Hi,

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

regards

Set Analysis , If or Multiplication

Tue, 02 Mar 2010 23:11:53 GMT

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?

Set Analysis , If or Multiplication

johnw — Tue, 02 Mar 2010 23:17:50 GMT

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.