topic Re: How to Sum Top 10 Rank in QlikView

How to Sum Top 10 Rank

d4rlie891 — Wed, 29 Jun 2016 07:04:29 GMT

Hi,

Anybody can tell me how to create a Measure to Sum Top 10 Rank ?

I have a measure but it doesn't Work :

Sum({<CUST_NAME = {=Rank(Sum({$<MONTHYEAR = {$(=max(MONTHYEAR))}, KOLEKTIBILITAS = {DPK}>} BALANCE_IDR)) <=10}>} BALANCE_IDR)

Thanks a lot

Re: How to Sum Top 10 Rank

sunny_talwar — Wed, 29 Jun 2016 14:24:40 GMT

Try this with double quotes:

Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {$(=max(MONTHYEAR))}, KOLEKTIBILITAS = {DPK}>} BALANCE_IDR)) <=10"}>} BALANCE_IDR)

Re: How to Sum Top 10 Rank

d4rlie891 — Thu, 30 Jun 2016 01:22:49 GMT

Hi Sunny,

The Result of this script is 0.

The script of SUM DPK is : Sum({<MONTHYEAR = {"$(=max(MONTHYEAR))"}>}BALANCE_IDR_DPK)

and the script of Sum Rank is : Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {$(=max(MONTHYEAR))}, KOLEKTIBILITAS = {DPK}>} BALANCE_IDR)) <=10"}>} BALANCE_IDR_DPK)

Thanks

Re: How to Sum Top 10 Rank

sunny_talwar — Thu, 30 Jun 2016 11:03:51 GMT

Would it be possible to share a sample of your application?

Re: How to Sum Top 10 Rank

d4rlie891 — Mon, 11 Jul 2016 07:40:03 GMT

Hi Sunny,

sorry for the delay, because there was a problem with the Qliksense Server.

I attach the Sample of Qvf.

Thanks