Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone tel me what is the disadvantage of SET ANALYSIS?
I am not sure what you mean, I assume you are comparing set analysis to something else, to be able to talk about (dis)advantages?
Compared to e.g. a nested if() in aggregation functions, set analysis is much faster (advantage!), but set analysis is evaluated once per chart, not per e.g. dimension value, so this could be a disadvantage in terms of usability.
Then, set analysis is a little bit more 'abstract', you need to really understand the concept of the associative DB and some little set theory, so the learning is a little way to go, but I won't call this disadvantage.
HI yojassamarth, Pls check the given points. I hope it will be help ful Although it is a new way of working with QlikView and opens up a wide range of functionality, a developer must handle Set Analysis carefully. A user often find it hard to look at Set Analysis expressions if they are not clearly stated as to what is actually shown. A developer must also be careful and make sure not to use Set analy- sis in ways that slow the application down. Set analysis can be CPU intense and thus Set Analysis should be tested in work situations to make sure that it does not slow the application down.
Regards, R.Bharat Kishore |
Hi Stephen,
I was little hesitant on replying this question but you guys have written it, so It has ignited my interest and hope to learn something.
You hit it really straight that set analysis becomes a little difficult to write and maitain and also if statements seems easy to write.
So, this can be seen as disadvantage but looking at the benefits it has that can be ignored.
But, one thing you said that
but set analysis is evaluated once per chart, not per e.g. dimension value, so this could be a disadvantage in terms of usability.
I am not able to relate to this statement!!
Hi Kishore,
Set analysis can be CPU intense and thus Set Analysis should be tested in work situations to make sure that it does not slow the application down.
I remember reading this somewhere in Qliktech Document but still someshow I feel that corresponding if condition will be more resource intensive and with this statement their intenstion will be make sure that set analysis is not taken as something which is over used as every body praises the set analysis and it is used even in places where it is not required.
One interesting post Matt has written on his blog about set analysis is
http://qvdesign.wordpress.com/2012/01/30/set-analysis-good-for-you-bad-for-your-ram/
To me the only disadvantage of set analysis is learning curve for developers who are going to learn it especially if they are not from technical background.
..
Ashutosh
hi bharat,
Can you explain me how set analysis is CPU intense???
yojas
PFA document.Go through this and you will get a better understanding.
Regards,
R.Bharat Kishore