Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
New Contributor III

Need Correction


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



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