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

[paulyeo11]

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

[paulyeo11]

my qvf

[sunny_talwar · Accepted solution]

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.

[paulyeo11]

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