3 Replies Latest reply: Jan 26, 2017 5:06 AM by Tan Yuan Kai RSS

    Problem facing when using Above(), Multi Dimension

    Tan Yuan Kai

      2017-01-20 18_40_34-Qlik Sense Desktop.jpg

      As you can see from the picture, the line for "Large Corp" disappeared because of the usage of Above function.

      I want to specific the calculation using above function refer to dimension "Quarter" and then split by Dimension "Size".

      Is there any solution for this?

      This is the formula of measure : (sum(Outstanding)-Above(Sum(Outstanding)))/Above(Sum(Outstanding))