topic Re: AGGR() Function in QlikView

AGGR() Function

prajapatiamar38 — Fri, 03 Jul 2015 05:52:38 GMT

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 — Fri, 03 Jul 2015 06:19:28 GMT

Hi Amarnath,

Try like this

=FieldValue('FieldNAME', 5)

Hope this helps you

Fri, 03 Jul 2015 06:30:53 GMT

Try this,

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

prajapatiamar38 — Fri, 03 Jul 2015 06:42:44 GMT

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 — Fri, 03 Jul 2015 06:53:14 GMT

Hii

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

Thanks

sasiparupudi1 — Fri, 03 Jul 2015 12:32:46 GMT

Please post some sample data