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.

       

      Thanks,

      Arvind