topic Re: FirstSortedValue function isn't considering negative values in the field in QlikView

FirstSortedValue function isn't considering negative values in the field

apoorvasd — Thu, 14 Sep 2017 14:35:15 GMT

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.

Re: FirstSortedValue function isn't considering negative values in the field

Clever_Anjos — Thu, 14 Sep 2017 14:43:01 GMT

That´s because you´re filtering the negative ones

[ACT vs AOP]={'>0'},

Re: FirstSortedValue function isn't considering negative values in the field

sunny_talwar — Thu, 14 Sep 2017 14:50:49 GMT

I am seeing the graph if I remove the condition

Re: FirstSortedValue function isn't considering negative values in the field

apoorvasd — Thu, 14 Sep 2017 15:04:48 GMT

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