topic FirstSortedValue in QlikView

FirstSortedValue

Sat, 24 Aug 2013 14:19:05 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.

Can i get some help here?

kaushiknsolanki — Sat, 24 Aug 2013 15:29:23 GMT

Hi,

Why dont you load the non zero values and then find the first sorted value.

Something like this.

Noconcatenate

Load *,Firstsortedvalue(Data,-Month) as Value resident Data where Data <> 0;

Drop table Data;

Regards,

Kaushik Solanki

whiteline — Sun, 25 Aug 2013 17:27:15 GMT

Hi.

It seems you could just use set analysis to calculate FirstSortedValue over the records where Data<>0.

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

Mon, 26 Aug 2013 09:15:31 GMT

Hi Whiteline,

Your solution works for the sample data i provided.But, i had lot of other calculations in the actual scenario.Did not work in my cse.

Thanks for your reply and your time:)

Thanks and Regards,

Pavan