Set Analysis Part 2

Donnie Bryson

This is a very simple example of using set analysis. First, we load data to use for playing.

playdata:
LOAD * Inline [
ID , name, children
1, Joe S, 3
2, Don B, 3
3, Joe C, 0
4, Don D, 4
5, Glenda S, 3
6, Mary B, 3
7, Helena C, 0
8, Ellen D, 4
];

Next we add a very simple sheet. The top left corner totals all the children in the data. The bottom left corner is a simple table that displays all the rows. The top right portion totals all the children that belong to ‘Don B’. The bottom right totals all the children that do not belong to ‘Don B’.

The titles are displaying the actual set statement required. The top one is summing all children belonging to ‘Don B’. The one below it is summing all children that do NOT belong to ‘Don B’.

Tag: set analysis

  • Qlik Set Analysis Part 1

    This post will be dealing with only the basic syntax. Personally, I found the syntax to the Qlik set analysis to be not intuitive at first. I am attempting to discuss the basics of its syntax.  First, however, let’s talk why we would use a set analysis. Set analysis is used for data already loaded…