Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
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
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
paulyeo11
Valued Contributor II

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

my qvf

MVP
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.

paulyeo11
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