Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
d4rlie891
New Contributor III

Need Correction

Hi,


Anyone can correct my Measure?

I just want to Sum Top 10 Rank.

The Result is OK, if I select a Year_Month, but if I don't select any Year_Month, the Result is incorrect.


This is my Measure:

Sum({<CUST_NAME = {"=Rank(Sum(BALANCE_IDR_DPK))<=10"}>} BALANCE_IDR_DPK)/1000000000

I need to add Max(MONTHYEAR) into that measure.


I try to create the measure like this, but it seem not working.

Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}>} BALANCE_IDR_DPK))<=10"}>} BALANCE_IDR_DPK)/1000000000

Thanks

Dmw

1 Reply

Re: Need Correction

How does your MONTHYEAR field look like? Is it a dual field (with numeric value) or is it text? Can you share a screenshot of MONTHYEAR field?

Community Browser