Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Somasundaram
Contributor III

Alternate for FirstSortedValue Function.

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

 

 


-Somasundaram
3 Replies

Re: Alternate for FirstSortedValue Function.

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

Re: Alternate for FirstSortedValue Function.

Can we use nested Aggr() function?


-Somasundaram

Re: Alternate for FirstSortedValue Function.

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