Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am using FirstSortedValue function in QlikView to pick up last value of a particular month in a field. The issue is, when the last value of a field in that particular month is negative, then the function is picking up next last value which is a positive number.
Of course there is a condition in the expression to pick up values greater than 0, but if i remove the condition, the graph doesn't display anything?
Any help on this?
Attached is the sample.
Thank you.
I am seeing the graph if I remove the condition
That´s because you´re filtering the negative ones
[ACT vs AOP]={'>0'},
I am seeing the graph if I remove the condition
Yes, even I do see it now. In the sample app that I have provided here, removing the condition works fine. But in the actual app it isn't working. I will check it.
Thank you very much