topic Selecting top 3 frequency count values in script: in QlikView

Selecting top 3 frequency count values in script:

Tue, 06 Sep 2011 07:04:51 GMT

Hi all..

I have a field. I want to make new field in script with only top 3 values of that field.

Plz Help..

Thanks in advance...

Tue, 06 Sep 2011 10:28:02 GMT

Try this:

A:
LOAD Name,
     ID,
     Region,
     Value
FROM

(ooxml, embedded labels, table is Sheet1);

B:
Load
Value as topValue,
recno() as recordno
resident A order by Value desc;

😧

Load

topValue as test

resident B where recordno <=3;

suniljain — Tue, 06 Sep 2011 12:03:44 GMT

If you want do at design level just see following similar king of example.

If(count( aggr(NODISTINCT Count(Mobile), Mobile )) >=3 ,count( aggr(NODISTINCT Count(Mobile), Mobile )))