topic Set Analysis in QlikView

Set Analysis

Fri, 21 Nov 2014 13:59:51 GMT

How can we arite a Set Analysis expression for displaying values corresponding to onlly top 20 rows of field. Expression should exclude all other values and show just top 20 rows values.

Please help.

Re: Set Analysis

MK_QSL — Fri, 21 Nov 2014 14:02:24 GMT

Use Dimension Limit

Re: Set Analysis

JonnyPoole — Fri, 21 Nov 2014 17:14:41 GMT

Here is the screenshot to assist

Dimension limits are available on charts and relate to the first expression (see below).

If you decide to 'show others' , make the number 21 (others counts as a display row...so top 20 + others = 21)

Re: Set Analysis

JonnyPoole — Fri, 21 Nov 2014 17:22:16 GMT

or if you need to do it on other expressions ( not the first) then your set analysis will be something like this:

=sum( {$<Country = {"=rank(Total sum(Sales)) <= 20"}>} Sales )