Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Chanty4u
Esteemed Contributor III

RE:Diference-Perfomance

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

1 Solution

Accepted Solutions

Re: RE:Diference-Perfomance

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

14 Replies

Re: RE:Diference-Perfomance

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

MVP
MVP

Re: RE:Diference-Perfomance

you can read this for if vs set analysis

Performance of Conditional Aggregations

balrajahlawat
Esteemed Contributor

Re: RE:Diference-Perfomance

Chanty4u
Esteemed Contributor III

Re: RE:Diference-Perfomance

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

Hi

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.

Chanty4u
Esteemed Contributor III

Re: RE:Diference-Perfomance

Thnks Mayil.

any such senario  shud use if only?

any example?

Re: RE:Diference-Perfomance

Re: RE:Diference-Perfomance

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.

Chanty4u
Esteemed Contributor III

Re: RE:Diference-Perfomance

Thnx raj.  & Mayil . now its clear