Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

how to be very strong in set analysis, how to go for it to be expert in this

11 Replies
Not applicable
Author

practice,

practice,

practice,

practice,

............

............

.............

practice,

practice..............

MayilVahanan

HI

Please refer this link.

It gives tips and learn about set analysis

http://www.qlikblog.at/1384/set-analysis-wizard-qlikview/

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
renjithpl
Specialist
Specialist

The very basic tips to use a set

First, write simple Sum

     Sum(Sales)

Next, Leave a Space between open bracket and Sales

     Sum( Sales)

then, Put the set syntax inbetween the space

     Sum({< put your set here >} Sales)

then, think about which set you want to try,

Eg- i want the latest year sales or the selected year sales only,

then for above eg, try this in between the set

Sum({< Year = { $(=Max(Year)) } >} Sales)

Explanation

Max(Year) will give the latest year sales, when you try in a text box you try as =Max(Year) which will result in eg(2012),

Year = Max(Year)

you should put "=Max(Year)" in a open and close bracket (=Max(Year)) then put one $ infront of it to treat it as value     $(=Max(Year))

Read the Qlikview-Set-Analysis-Presentation.pdf to understand more about teh syntax and rest of the things

when you write your first set like above, you will learn automatically rest of it

Set anaysis with syntax looks scary but when you try like above you will able to write your own sets.

All the best.

Sorry if i am wrong guys...

renjithpl
Specialist
Specialist

you can try your set in straight table without renaming the expression, bring your mouse over the expression you create, it will show you whether you got the result right or wrong.

Cheers!!

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

If you want to know Set Analysis, you have to understand 3 part of Set Analysis: SET IDENTIFIER, SET MODIFIER & SET OPERATOR.

Use the attachment from Mayil Vahanan or pick up Reference manual for QlikView.

Regards,

Gab

Not applicable
Author

I want to know that , in set analysis when I am writing any condition for selection ,

ex. =sum({$<CategoryName={"=sum({1-$<[Category Desc]={'0-3 Years'}>}Sales)>0"}>}Sales)

what would be the result of above condition,

when I execute this , is it the data excluded from whole data of [Category Desc]={'0-3 Years'} or what exactly the data is????

and when I am selecting any other criteria , what data I will get after above set condition??

pls can any one explain me how does this work exactly??

Not applicable
Author

I tried this, it is showing me only the data of what condition I have put..

and for selecting anything else it is 0 only..

renjithpl
Specialist
Specialist

Please can you explain what exactly you want in that set, then may be someone can help you..

1-$ excludes current selection and give data for the rest.

Not applicable
Author

Hi Renjith,

     Your suggestion helped to understand setanalysis easily..Can you please tell me if i want to get the customers sales for the particular year and also to compare with the previous year. I tried the below one to get the result

sum({$<Year={$(=OnlyYear))}>} Sales)

Thanks in advance

Sakthi