topic Re: How to get top n number of total in Text field in QlikView

How to get top n number of total in Text field

erichuang — Sat, 16 Nov 2024 04:36:22 GMT

Hi all,

As the attachment, I made an accumulation in straight table and highlight following data:

1. Top 5

2. Data >= 80%

I can highlight the top 5 data and show it in text field, but if I want to find specific number >= 80% and show it in text field, how to do it? For example in the attachment, top 11 >= 80%, is there any way to get '11'?

Re: How to get top n number of total in Text field

tresB — Thu, 31 Jan 2019 07:13:16 GMT

You could try like:

=Count({<ITEM={"=Aggr(rangesum(above(Sum(AMT)/Sum(TOTAL AMT),0,rowno()))
		 , (ITEM,(=Sum(AMT), Desc))) <0.8"}>}  ITEM)
  +1

Re: How to get top n number of total in Text field

erichuang — Thu, 31 Jan 2019 07:54:41 GMT

Hi,

Thanks for your reply!

I have tried your suggestion but the result is '1' in text field. Do I miss something?

Thanks a lot!

Re: How to get top n number of total in Text field

tresB — Thu, 31 Jan 2019 08:02:05 GMT

Have you checked the app I attached? Isn't that working?

Re: How to get top n number of total in Text field

erichuang — Thu, 31 Jan 2019 08:12:03 GMT

Hi,

I have checked the attached app and the result in text field also shows '1'.

My qlikview version is 11.20.12904.0 SR12.

Thanks a lot!

Re: How to get top n number of total in Text field

tresB — Thu, 31 Jan 2019 09:23:59 GMT

Ohh.. I have used sortable aggr() in the expression and that would work in qv 12+ versions.

Re: How to get top n number of total in Text field

sunny_talwar — Thu, 31 Jan 2019 12:47:55 GMT

For your version of QlikView, you can play around with the idea that was initially proposed here

ABC Analysis in Qlikview