Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP

Set Analysis Beginners Guide v2.0.docx

Employee
Employee

Set Analysis Beginners Guide v2.0.docx

Hello All,

When I first began using QlikView, I found Set Analysis (and sometimes still do) very difficult to understand. This provides a useful step by step guide on how to understand Set Analysis.

I hope this is useful to you all.

Labels (2)
Attachments
Comments
Not applicable

Nice Work....

0 Likes
Partner
Partner

Hi.

There is a point when you say that max(Month) returns 0.

I think there is a problema with formats. max(Month) of January, February March is not 0, is 3,

When you say sum({$<Month={'$(vMaxMonth)'}>}Sales),March is not equal to 3, so it does not work. It ignores the Month subset.

But,.... if we say sum({$<Month={'<=$(vMaxMonth)'}>}Sales) it does work, so:

either we create a vMaxMonthLetters, or we do...

sum({$<Month={'>=$(vMaxMonth)<=$(vMaxMonth)'}>} Sales)

and it works.

Salutes.

0 Likes
Not applicable

Good work !!

0 Likes
Valued Contributor III

Good one..

0 Likes
Not applicable

example files please

0 Likes
Valued Contributor

Hi Mark,

This guide seems to be *largely* based on the series of posts I wrote at The Magic Of Set Analysis | iQlik - Everything QlikView., as well as in our book QlikView 11 for Developers: Barry Harmsen, Miguel Garcia: 9781849686068: Amazon.com: Books .

It's great to see that you've found my resources helpful, but it'd be nice if you at least give credit when credit is due and avoid plagiarism. I'm not saying you copied and pasted the content directly, but most part of the guide you've published is identical to the original content; even the examples provided, and sequence of steps, are identical. I honestly can't find any original input in this document.

Anyway, it's great to see more people are taking advantage of this resource

For everyone looking to get more in-depth in this awesome QlikView functionality, and get the example files associated with the examples, please head on to The Magic Of Set Analysis | iQlik - Everything QlikView.

Mike.

Version history
Revision #:
1 of 1
Last update:
‎2014-01-14 03:58 AM
Updated by:
Employee