Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this with double quotes:
Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {$(=max(MONTHYEAR))}, KOLEKTIBILITAS = {DPK}>} BALANCE_IDR)) <=10"}>} BALANCE_IDR)
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
Would it be possible to share a sample of your application?
Hi Sunny,
sorry for the delay, because there was a problem with the Qliksense Server.
I attach the Sample of Qvf.
Thanks