topic Re: Alternate for FirstSortedValue Function. in QlikView

Alternate for FirstSortedValue Function.

Somasundaram — Sat, 16 Nov 2024 21:51:35 GMT

Hi,

I am using firstsortedvalue function for getting date value. I have saved as a variable and using multiple places, some of the time I am getting the wrong value. One place is showing correct and another place is showing wrongly.

Is there any way to implement firstsortedvalue functionality with out using firstsortedvalue function?

Help would be appreciated.

Regards,

Somasundaram

Re: Alternate for FirstSortedValue Function.

sunny_talwar — Tue, 20 Nov 2018 14:31:59 GMT

There is... you can use Aggr() with if statement to do it...

Re: Alternate for FirstSortedValue Function.

Somasundaram — Tue, 20 Nov 2018 14:36:01 GMT

Can we use nested Aggr() function?

Re: Alternate for FirstSortedValue Function.

sunny_talwar — Tue, 20 Nov 2018 14:44:53 GMT

I would think so... not sure what you have so cannot really say with confidence 🙂