topic First non zero value in QlikView

First non zero value

Thu, 29 Aug 2013 05:33:47 GMT

Hi all,

Is there a way to get First non zero sorted value?

If the data is as above and my expression is FirstSortedValue(Data,-Month) i would get 0.

But i want 200 which is the firstNONZEROsortedvalue from the last.

CELAMBARASAN — Thu, 29 Aug 2013 05:57:37 GMT

try like this

FirstSortedValue({<Data={">0"}>}Data,-Month)

rajeshvaswani77 — Thu, 29 Aug 2013 06:07:33 GMT

Please refer this post.

thanks,

Rajesh Vaswani

MayilVahanan — Thu, 29 Aug 2013 06:10:53 GMT

Try like this

FirstSortedValue({<Data={'=Data>0'}>} Data,-Month)

or as mentioned by celambarasan

Thu, 29 Aug 2013 06:24:48 GMT

Thanks all.

There is another problem,

My actual values are not from a field called 'Data'

It is actually an aggregation over date

i.e Data = Aggr(SUM(Field1),Date)

Hence i cant use the above expressions.

Rajesh,

the earlier post also was by me:)But,again the same scenario as explained above.

CELAMBARASAN — Thu, 29 Aug 2013 06:30:06 GMT

Can you attach sample?