topic Re: IF Vs Set Analysis in QlikView

IF Vs Set Analysis

Wed, 03 Sep 2014 05:30:21 GMT

hi,

Can anyone please say me the difference between IF statement and set analysis

Is it possible to use IF statement instead of set analysis? if it is please explain me

Thanks in advance

Re: IF Vs Set Analysis

sundarakumar — Wed, 03 Sep 2014 05:32:11 GMT

You can very well use If instead of Set analysis. But the performance will be better if you use set analysis, where as it will be impacted while using if statements.

Creating a flag in the balck end and using it in set analysis is always preferable.

-Sundar

Re: IF Vs Set Analysis

tresB — Wed, 03 Sep 2014 05:34:22 GMT

Couple of good discussions:

Set Analysis vs if()

Performance: Set Analysis vs. IF vs. Multiplication

Re: IF Vs Set Analysis

vardhancse — Wed, 03 Sep 2014 05:35:33 GMT

Both If and Set Analysis are one kind of functions.

The only difference is that by using set analysis, we can increase the performance.

Re: IF Vs Set Analysis

sundarakumar — Wed, 03 Sep 2014 05:36:54 GMT

Because set analysis made on numeric fields yield better performance when compated to set analysis made on text

1. sum({<Country={'India','Chine'}>}sales)

2. sum({<country_check_flag={1}>}sales)

2 performs best when compated to 1

-Sundar

Re: IF Vs Set Analysis

jagan — Wed, 03 Sep 2014 05:39:39 GMT

Hi Logesh,

We can use both If and Set Analysis expression, but when compared the Set Analysis has upper hand by performance and ease of usability. If you have many conditions then you have use many if else and logical operators but in set analysis it is very very simple.

Using If() will have performance issues, since we need to evaluate row wise.

Set Analysis has some good features like P() and E(), which is not possible with If easily.

Hope this helps you.

Regards,

Jagan.

Re: IF Vs Set Analysis

Wed, 03 Sep 2014 08:50:53 GMT

Thanks for your replies...very useful