Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

FirstSortedValue doesnt work

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

Tags (1)
4 Replies
MVP
MVP

Re: FirstSortedValue doesnt work

Try like: = MinString(ACNT)

PFA

Not applicable

Re: FirstSortedValue doesnt work

Thanks Tresesco.

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

manojkulkarni
Valued Contributor II

Re: FirstSortedValue doesnt work

use

sum(aggr((AMT),ACNT))

MVP
MVP

Re: Re: FirstSortedValue doesnt work

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

PFA

Community Browser