topic FirstSortedValue doesnt work in QlikView

FirstSortedValue doesnt work

Fri, 07 Feb 2014 05:35:17 GMT

Dear All,

I have attached my two QV documents in which i used firstsortedvalue function.

As per my understanding i passed parameters, but its not working.

My aim to show CID and only the first ACNT from each CID group and sum of that particular ACNT.

Thanks & Regards,

Aqeel Nawaz

tresB — Fri, 07 Feb 2014 05:39:37 GMT

Try like: = MinString(ACNT)

PFA

Fri, 07 Feb 2014 05:46:12 GMT

Thanks Tresesco.

But what to do with the sum of Amount for only that particular ACNT.

manojkulkarni — Fri, 07 Feb 2014 05:56:10 GMT

use

sum(aggr((AMT),ACNT))

tresB — Fri, 07 Feb 2014 05:57:52 GMT

Use calculated dimension like: =Aggr( MinString(ACNT), CID)

PFA