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!

[Sokkorn]

Hi,

I'm not sure attached file below can help you on set analysis or not. Let take a look.

Regards,

Sokkorn

[#3]

Please have a look at this

http://robwunderlich.com/downloads/

Will keep you updated if I get any other materials. Above document is quite useful for all the newbie's. It covers all the topic including Set Analysis.

[#4]

Sokkorn: Thank you, but I actually have already seen this. This has good content, and I think it could be great if coupled with a speaker, but it still isn't comprehensive. That said, I appreciate the input, and I bet others will find it useful.

[#5]

Thank At titude. I'll have a look.

[IAMDV]

Hi,

I'm planning to make series of video tutorials on Set Analysis. I've already covered tutorials on functions like FirstSortedValue and other QlikView functions. Here is the link to my blog :

www.QlikShare.com

Although, I'd strongly recommend you to explore Stefan's blog (link below), he had created Set Analysis Expression Generator. So you can use it until you become comfortable with the Expressions or you can reverse engineer and learn from this tool.

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

I hope this is useful!

Cheers,

DV

[#7]

That's great Deepak! Thank you. I think that it's really smart of you to cover this topic in depth. It seems to me that this is an area that could be covered a lot more thoroughly (reducing the time-consuming need to learn the vernacular through reverse engineering).

I'm going through Wunderlich's stuff now. So far, I've found some really useful nuggets, but as of yet, nothing really homing in on what I described above. I'd actually already bookmarked your blog, but hadn't gotten to it I'll have a look today.

Best,

Nick

[IAMDV]

You're welcome Nick.

Rob Wunderlich, Stefan Walther and Miguel Angel Baeyens along others are the best guys on community. So please check their blogs or read their posts...that's how  I've learnt I'm learning QlikView.

I'll update this thread once I create the videos.

Cheers,

DV

www.QlikShare.com

[mazacini]

Hi Nick

I actualy have a webinar file that accompanies the pdf. It's about 27MB - I found it on the web, but can't find a link to it anymore.

Just a general point from my own experience.

I came to Qlikview from an excel background, and have found the lack of reference material frustrating.

I found Set Analysis especially tricky. In the end, I relied mainly on the contents of the help section - i printed it out and always had it by my side when working through Set Analysis problems.

It may not be much of a comfort to you, but I (slowly!) got a grasp of the basics - and there was always great assistance from the community with specific problems.

Joe

PS - I think there is a bug in Set Analyis where the red underlines sometimes indicate errors that are not there, but I can't be certain of that

[Gabriel]

Hi Nick,

With regards to learning Set Analysis, i personally think it is a continuous learning. Also, I found out that if I break whatever I want to analyse down to this 3 basic part (Identifier, Modifier, Operator), it’s a lot easier. If i am in your situation I will focus on understanding how these 3 set analysis integral works and see how to blend them together.

I will also recommend starting bit by bit, little by little, accomplishing small task.

Download reference manual (attached) and go through Set Analysis section (page 365 upward) might be of help.

Regards,

Gabriel