# Qlik Sense App Development

Valued Contributor II

## If(Not IsNull([YTD Variance]),1,0) in QV how to do this in QS ?

Hi All

In QV if i place the below expression :-

If(Not IsNull([YTD Variance]),1,0)

And set the mode to Accumulation.it will count the number of company.

May i know how to achieve this in QS ?

Paul

1 Solution

Accepted Solutions
MVP

## Re: If(Not IsNull([YTD Variance]),1,0) in QV how to do this in QS ?

This expression kind of works:

If(Column(2), RangeSum(Above(If(Not IsNull([YTD Variance]),1,0), 0, RowNo())))

The issue is that it shows null rows as well. Not sure why it does it, but I have seen the same problem in various different occasions with Qlik Sense. I don't have a solution for this, neither do I understand the reason.

3 Replies
Valued Contributor II

my qvf

MVP

## Re: If(Not IsNull([YTD Variance]),1,0) in QV how to do this in QS ?

This expression kind of works:

If(Column(2), RangeSum(Above(If(Not IsNull([YTD Variance]),1,0), 0, RowNo())))

The issue is that it shows null rows as well. Not sure why it does it, but I have seen the same problem in various different occasions with Qlik Sense. I don't have a solution for this, neither do I understand the reason.

Valued Contributor II

## Re: If(Not IsNull([YTD Variance]),1,0) in QV how to do this in QS ?

Hi sunny

Thank you very much for your solution , yes it is not working in QS. okay i will keep in mind that for Accumulate use :-

RangeSum(Above

Paul