How to Sum Top 10 Rank

[d4rlie891]

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

[sunny_talwar]

Try this with double quotes:

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

[d4rlie891]

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

[sunny_talwar]

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

[d4rlie891]

Hi Sunny,

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

I attach the Sample of Qvf.

Thanks