First non zero value

[#1]

Hi all,

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

Month	Data
Jan	100
Feb	100
Mar	300
Apr	600
May	100
Jun	700
Jul	200
Aug	0
Sep	0
Oct	0
Nov	0
Dec	0

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]

try like this

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

[rajeshvaswani77]

Please refer this post.

http://community.qlik.com/message/381968#381968

thanks,

Rajesh Vaswani

[MayilVahanan]

HI

Try like this

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

or as mentioned by celambarasan

[#5]

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]

Can you attach sample?