Set Analysis

[#1]

Hi,

What is Set Analysis? And what is the advantage of using it?

Regards,XXX

[amien]

Thank you John .. very clear.

[#3]

Hi john

can u plese help me on this

i have a book mark object in my sheet having no.of book marks if i am selecting one book mark name from the object

i need to set the selected book mark name into one variable.when i am clicking the button.

is it possible ...............?

Please find the below link for original post

LINK

Many Thanks

vasu.I

[#4]

Can anyone expand this set, which is taken from the examples above, so that the criteria is changed from '> 1000000' to '>1000000<5000000', that's between 1000000 and 5000000?

I cant seem to get it working...

sum( {$<Customer = {"=Sum({1<Year = {2007}>} Sales ) > 1000000"}>} Sales )
returns the sales for current selection, but with a new selection in the "Customer" field: only customers who during 2007 had a total sales of more than 1000000.

[#5]

Hi..,

Came across this wizard for creating the Set Analysis expression..
This might be useful :

Set Analysis Wizard for QlikView | qlikblog.at

[#6]

Hi..,

Came across this wizard for creating the Set Analysis expression..
This might be useful :

Set Analysis Wizard for QlikView | qlikblog.at

[everest226]

http://www.learnqlickview.com/qlikview-set-analysis-basics/

[pitleanil3]

sis

Thank you Tresesco B. This ans is very helpful for me.