topic Re: RE:Diference-Perfomance in QlikView

RE:Diference-Perfomance

Chanty4u — Wed, 09 Mar 2016 07:55:00 GMT

Hi all,

Which is the best method to perform the qvw?

using IF conditions or set analasys? what is the major differnce?

we can perform the caaluculation from both set and if conditions aswell?

so which is better at perfomance side? to increase the perfomance of the QVW?

anyone explain with small example?

Thanks in advance

Suresh chanty

Re: RE:Diference-Perfomance

tamilarasu — Wed, 09 Mar 2016 07:57:58 GMT

Hi Chanty,

Performance wise set analysis is faster. Below links might be helpful to understand the difference.

Difference between IF condition and Set analysis

Using “IF” in expressions vs using “Set Analysis” | QlikView Help, Tips & Hints

Re: RE:Diference-Perfomance

maxgro — Wed, 09 Mar 2016 07:59:18 GMT

you can read this for if vs set analysis

Performance of Conditional Aggregations‌

Re: RE:Diference-Perfomance

Anonymous — Wed, 09 Mar 2016 08:01:52 GMT

might be helpful for you?

Using “IF” in expressions vs using “Set Analysis” | QlikView Help, Tips & Hints

Difference between IF condition and Set analysis

Re: RE:Diference-Perfomance

Chanty4u — Wed, 09 Mar 2016 08:09:25 GMT

thnx raj..it was nice. but it is shwng both are same?

what is the major fact about this? in your way raj?

Re: RE:Diference-Perfomance

MayilVahanan — Wed, 09 Mar 2016 08:13:58 GMT

Performance wise - Use set analysis

In some situation, we can't use set analysis . In that case, we can use If condition.

Try to bring some flag from script in order to avoid more complex set analysis.

Re: RE:Diference-Perfomance

Chanty4u — Wed, 09 Mar 2016 08:17:54 GMT

Thnks Mayil.

any such senario shud use if only?

any example?

Re: RE:Diference-Perfomance

MayilVahanan — Wed, 09 Mar 2016 08:26:40 GMT

See below

how to solve this logic

Re: RE:Diference-Perfomance

tamilarasu — Wed, 09 Mar 2016 08:40:53 GMT

Hi Chanty,

If condition evaluates for each row of data in chart where as Set analysis calculated once per chart and not row by row. So Set Analysis would perform faster.

Re: RE:Diference-Perfomance

Chanty4u — Wed, 09 Mar 2016 09:07:31 GMT

Thnx raj. & Mayil . now its clear

Re: RE:Diference-Perfomance

jagan — Wed, 09 Mar 2016 09:13:49 GMT

Hi,

Using SEt analysis will have better performance when compared to If(). Also it is easier to implement complicated conditions in Set analysis, in If() you have to write lengthy expressions. Sometimes may not be possible using If().

Hope this helps you.

Regards,

jagan.

Re: RE:Diference-Perfomance

jagan — Wed, 09 Mar 2016 09:14:26 GMT

For your Info, you won't see the difference between both for small set of data, but you can see this clearly for huge data.

Regards,

Jagan.

Re: RE:Diference-Perfomance

Chanty4u — Wed, 09 Mar 2016 09:24:05 GMT

thnx jagan.

Re: RE:Diference-Perfomance

avinashelite — Wed, 09 Mar 2016 09:31:11 GMT

check this too

Optimize UI Performance with Flags and Set Analysis

Re: RE:Diference-Perfomance

Chanty4u — Wed, 09 Mar 2016 09:32:23 GMT

thnx avinash.