Learning Set Analysis from Scratch

[#1]

I am a week into my Qlikview education After going through multiple QV tutorials, I feel that I have a good grasp of the basics. However, writing and editing expressions is a big part of my job, and I haven't found any good resources on the topic.

The book Hello Qlikview has a chapter devoted on this Set Analysis issue, but that is the only resource that I've found to be especially useful. I realize there is a ton of blogs out there, but any given blog post only seems to address a narrow topic. That's great for some, but I need a broader education.

The Set Analysis Wizard (found here: http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=_CNGH) is good, but it's expressions sometimes have errors. More importantly, this wizard does not help me understand the rules that underlie the syntax of any given expression (i.e. what drives using curly brackets vs. parentheses? and when do I use < & >? These are examples of questions I have that I would hope a tutorial would answer).

Community: Do you know of any good resources that provide an education specifically on Set Analysis?

Any suggestions would be much appreciated. Thank you!

[#2]

thnks this pdf is really very good.. here all the basic is given... thnks..:)

[rwunderlich]

I would also recommend the book "Qlikview 11 for Developers"

http://www.packtpub.com/qlikview-11-developers/book

http://www.amazon.com/QlikView-11-Developers-Barry-Harmsen/dp/1849686068

It has a great chapter on Set Analysis

-Rob

[#4]

Thanks,

             Rob Wunderlich

[#5]

Another tip:

http://iqlik.wordpress.com/category/set-analysis/

[cheburashka]

Hi,

I jus started learning Qlikview one month ago with this book "Qlikview 11 for Developers".

Chapter 11 "Set Analysis and Point In Time Reporting" has a nice example where they explain how to build up your Set-analysis syntax.

The content of the chapter:

[#7]

Thanks a lot. It really helped to gain an understanding about set analysis. appreciate your help.

[#8]

Thanks for sharing valuable information.

Regards,

KC

[#9]

very nice information!

i used it .. in my project      CAL_Sel =  Current Year

Sum({<CAL_sel ={">=$(=Date(addmonths(Max(CAL_sel),-12), 'MMM-YY')) <=$(=Date(addmonths(Max(CAL_sel), -1),  'MMM-YY'))"} >} Amount)

[#10]

I am not understand for SET ANALYSIS, How to use for set analysis?

plz reply me sudhakar.qlikview03@gmail.com