Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
my qvf
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.
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