Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

d4rlie891
New Contributor III

How to Sum Top 10 Rank

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

4 Replies

Re: How to Sum Top 10 Rank

Try this with double quotes:

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

d4rlie891
New Contributor III

Re: How to Sum Top 10 Rank

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)

Sum Top 10 Rank.jpg

Thanks

Re: How to Sum Top 10 Rank

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

d4rlie891
New Contributor III

Re: How to Sum Top 10 Rank

Hi Sunny,

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

I attach the Sample of Qvf.

Thanks

Community Browser