I have difficulty on total up my qlikview chart by only sum up for top 10 figure which has exclude for the surpass value is null in dimention. I think many way but stll don;t get the right figure yet. I would appreciate if any of you can give me a hand on this. Enclosing the picture for you to refer. and for you information i have set to display only 10 record in Presetation setting.
sum([Gross Rental]+[AGross Rental]
As you can see the total up for all the record is 18191233 if for only surpassed dimention, the value should be 2334702.04 instead.
Hi, i have search around the forum and i found this script seen work but, it still include for the 'surpass value when null' dimention may i know how can i amend the script to not include those null value dimention and i have check for teh surpass value checkbox?