11 Replies Latest reply: May 31, 2018 5:23 AM by Arvind Kumar Jha RSS

    Null values using above function in Qlik

    Arvind Kumar Jha

      Hello Team,


      I have a dataset from Jan 2015 to Mar 2018.


      I have used the below function :

      Measure : count([Employee #])/above(count([Employee #]))

      Dimension Drill Down : Year , Quarter , Month


      Year :

      The first year does not have value as there is no value above it

      On drilldown Year 2017 ,Q4 has null value ,

      On drilldown Q1,March has null value.


      Ideally Q4-17 should not have null value as it's above function should call Q3-17 and similar for month.


      For every selection there is null value for one field value.


      How to fix it , is there any alternate mechanism.