Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
you can read this for if vs set analysis
thnx raj..it was nice. but it is shwng both are same?
what is the major fact about this? in your way raj?
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.
Thnks Mayil.
any such senario shud use if only?
any example?
Hi
See below
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.
Thnx raj. & Mayil . now its clear