Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

diadvantage of set analysis

Can anyone tel me what is the disadvantage of  SET ANALYSIS?

5 Replies
swuehl
MVP
MVP

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.

bharatkishore
Creator III
Creator III

  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

Not applicable
Author

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

Not applicable
Author

hi bharat,

Can you explain me how set analysis is CPU intense???

yojas

bharatkishore
Creator III
Creator III

PFA document.Go through this and you will get a better understanding.

Regards,

R.Bharat Kishore