Hands on Set Analysis from the ground up

Dalton_Ruer — Tue, 10 May 2022 19:17:46 GMT

Over the past few weeks I have been trying to answer some forum questions in my spare time. It really hasn't surprised me that about 25% of the questions require some form of Set Analysis. For other questions I can say "Oh just see the help for the ABC() function." But I can't just do that for set analysis because ...

I know that one of the most awesome features of Qlik is that you can do analysis on "sets" of data.

But, I also know that one of the most feared features of Qlik is that you can do analysis on "sets" of data.

By that I mean that you start out seeing these ridiculous, Greek looking, formulas that make no sense at all.

If you are an old pro, that's awesome and you are probably helping answer soooooooo many questions that involve Set Analysis so for that I thank you. If you are new to Qlik, or have been intimidated by this in the past, then this document is for you.

I've attached a hands on workshop to help you learn to understand this amazing feature that Qlik provides. I've also provided a QVF file you can use that is the starting point for the lab. Here is a starting sample:

The end of the workshop document contains a lot of links to additional information and offers a cheat sheet that even experience Qlikkies can keep to refer to.

Environment:

Re: Hands on Set Analysis from the ground up

John3 — Mon, 03 May 2021 16:24:11 GMT

Thanks Dalton Ruer.

Re: Hands on Set Analysis from the ground up

vikasmahajan — Sun, 27 Feb 2022 05:08:56 GMT

Excellent

Re: Hands on Set Analysis from the ground up

AlexPolorotov — Mon, 19 Dec 2022 11:23:42 GMT

Thank you @Dalton_Ruer !
With the same intention, I've created https://qata.io, a Set Analysis Simulator platform for Qlik enthusiasts to build Set Analysis muscles.

article Hands on Set Analysis from the ground up in Official Support Articles

Hands on Set Analysis from the ground up

Environment:

Re: Hands on Set Analysis from the ground up

Re: Hands on Set Analysis from the ground up

Re: Hands on Set Analysis from the ground up