topic Re: Flag for Top 50 records in Report builder in QlikView

Flag for Top 50 records in Report builder

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to generate flag for top 50 records for Revenue filed in report builder (Dynamic chart).

I have to show flag for top 50 as YES and rest of NO.

For ex:

Flag field should have YES, NO values. If I select flag field from dimension list and Revenue from expression list Report look like

ID, Flag, Revenue, desc order

D111, YES, 10200, 100

C543, YES, 10100, 99

U211, YES, 5000, 50

V001, NO, 4900, 49

A011, NO, 1, 1

Note : Desc Order filed has been provided for understanding.

Regards,

Nihhal.

Re: Flag for Top 50 records in Report builder

agustinbobba — Wed, 06 Apr 2016 14:14:32 GMT

Hi Nihhal,

Maybe you can do it in the script

Load
     ID,
     Revenue,
     IF(Revenue > 50 , 'Yes', 'No') AS Flag
From XXX;

Best regard

Agustin.

Re: Flag for Top 50 records in Report builder

nihhalmca — Wed, 06 Apr 2016 15:10:27 GMT

Thanks for reply.

Just i have given example as revenue 50. I am expecting top 50 values in revenue filed. (50 is count, should not be revenue value)

Re: Flag for Top 50 records in Report builder

amit_saini — Wed, 06 Apr 2016 15:15:57 GMT

Try:

I guess you can use Rank function for top 50 and than later use if statement based on Rank (Revenue) for Yes and No.

Thanks,

Re: Flag for Top 50 records in Report builder

nihhalmca — Wed, 06 Apr 2016 15:43:24 GMT

Thanks for response.

For all i know QV does not have any rank funcion for edit script (script level), can you share sample script please.

Re: Flag for Top 50 records in Report builder

nihhalmca — Wed, 06 Apr 2016 16:26:23 GMT

I got the solution by using of rec().

Re: Flag for Top 50 records in Report builder

Anonymous — Wed, 06 Apr 2016 18:01:30 GMT

Table:

LOAD * Inline [

NAME, VALUE

A, 4.4

B, 0.9

C, 3.2

D, 1.92

];

Table1:

LOAD *,

If(Rank <= 50, 'Y', 'N') as flag;

LOAD NAME,

VALUE,

AutoNumber(VALUE) as Rank

Resident Table

Order By VALUE desc;

DROP Table Table;