AGGR() Function

[prajapatiamar38]

Hi experts,

How to fetch 5th last value from coloumn using Aggr() function but without using  max function.

For eg: If i have one coloumn in that if there is 20 values I want 5th value from the bottom in front end.

How can i....

Please help me...

Thanks in advance

[Anonymous]

Hi Amarnath,

Try like this

=FieldValue('FieldNAME', 5)

Hope this helps you

[#3]

Try this,

=FieldValue('FieldName', FieldValueCount('FieldName')-4)

[prajapatiamar38]

Hi qlikview novice,

Thanks for your reply As per your exp it is giving 5th value from top but i want 5th value from the bottom.

Thanks

[prajapatiamar38]

Hii

Thanks for your solution it is working fine but i want using aggr() function.

Thanks

[sasiparupudi1]

Please post some sample data