4 Replies Latest reply: Oct 14, 2012 1:46 PM by Jeffrey Chan RSS

    Sum for display figure only?

      Hi,

       

      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]

      )

       

      Picture1.png

      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.

      Thanks you first