topic Re: Percentage by Column by Dimension in QlikView

Percentage by Column by Dimension

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

Hi All,

I have 1 filed that have number ofrecords for example.1000 recs

I need 26th of percentage of all the records.

how to get this.Please provide solution asap.

Regards,

Sunitha

Re: Percentage by Column by Dimension

MohammedMustaq — Tue, 22 Jan 2019 08:40:47 GMT

Hello,
In general 1000*26/100=260 Records

Try
But if you need to write in Expression!
=Count(recs)*26/100.

=Count([Field Name])*26/100

Thanks
Mustaq

Re: Percentage by Column by Dimension

LVillage — Wed, 23 Jan 2019 06:52:18 GMT

Hi,sonysree88

How about the following method?

1.Assign row numbers in the load script.

====<example:load script>=====

LOAD
rowno() as row,
Field1
FROM
…
;

2.Create a flag to determine the top 26%.(1:Top 26% 0:other)

====<example:Listbox Formula>=====

=if(row > round(max(total row)*0.26),0,1)

3.If you select "1" in the list box, you will be able to get 26% of records

Thanks.