Null values using above function in Qlik

[arvindjha2050]

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

[arvindjha2050]

Thanks for the response Hans.

How excatly RowNo() function will help?

Regards,

Arvind

[hacr]

Maybe I didn't understand your problem fully, but being able to determine wether or not to use the "above()" based on the row number?

[arvindjha2050]

Actually in my case it's a drilldown and with "above" function a null value comes at each and every step of a drilldown for 1st value which is not desirable as the value is present for the above rows.