topic Re: Learning Set Analysis from Scratch in QlikView

Learning Set Analysis from Scratch

Mon, 06 Aug 2012 23:55:51 GMT

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!

Re: Learning Set Analysis from Scratch

Sokkorn — Tue, 07 Aug 2012 02:15:58 GMT

Hi,

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

Regards,

Sokkorn

Re: Learning Set Analysis from Scratch

Tue, 07 Aug 2012 07:01:56 GMT

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.

Re: Learning Set Analysis from Scratch

Tue, 07 Aug 2012 15:23:52 GMT

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.

Re: Learning Set Analysis from Scratch

Tue, 07 Aug 2012 15:24:27 GMT

Thank At titude. I'll have a look.

Re: Learning Set Analysis from Scratch

IAMDV — Tue, 07 Aug 2012 18:40:27 GMT

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,

Re: Learning Set Analysis from Scratch

Tue, 07 Aug 2012 18:45:18 GMT

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

Re: Learning Set Analysis from Scratch

IAMDV — Tue, 07 Aug 2012 19:15:40 GMT

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,

www.QlikShare.com

Re: Learning Set Analysis from Scratch

mazacini — Wed, 08 Aug 2012 07:12:06 GMT

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

Re: Learning Set Analysis from Scratch

Gabriel — Wed, 08 Aug 2012 13:53:18 GMT

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

Re: Learning Set Analysis from Scratch

Tue, 22 Jan 2013 07:21:47 GMT

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

Re: Learning Set Analysis from Scratch

rwunderlich — Tue, 22 Jan 2013 07:51:45 GMT

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

Re: Learning Set Analysis from Scratch

Fri, 25 Jan 2013 12:15:19 GMT

Thanks,

Rob Wunderlich

Re: Learning Set Analysis from Scratch

Mon, 28 Jan 2013 13:09:33 GMT

Another tip:

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

Re: Learning Set Analysis from Scratch

cheburashka — Thu, 07 Feb 2013 12:39:31 GMT

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:

Re: Learning Set Analysis from Scratch

Mon, 20 Oct 2014 05:13:34 GMT

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

Re: Learning Set Analysis from Scratch

Tue, 19 May 2015 08:31:30 GMT

Thanks for sharing valuable information.

Regards,

Re: Learning Set Analysis from Scratch

Tue, 26 May 2015 08:59:25 GMT

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)

Re: Learning Set Analysis from Scratch

Sat, 03 Oct 2015 06:53:11 GMT

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

plz reply me sudhakar.qlikview03@gmail.com