Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

FirstSortedValue in a Straight Table

Hi

I am trying to get the First line of data in the following Table

Claim NumberClaim Done DateSum([Claimant Reserve Payment])FirstSortedValue(Sum([Claimant Reserve Payment]), [Claim Done Date])
AE00082703/07/2012

9108.2

-

AE000827

04/07/201216358.2-
AE00082705/07/201210042.2-
AE00082706/07/201210042.2-
AE00082709/07/201210042.2-

What I was hoping for was the table just to show the first line so I know what the reserve was on the earliest date.  As you can see my expression using firstsortedvalue is just returning nulls

Can anyone help Please

Regards

Matt

1 Solution

Accepted Solutions
Not applicable

Re: FirstSortedValue in a Straight Table

If you are using QV11 use dimension limits and show first row.

If not use the following experssion for Reserve

Sum({<[Claim Done Date]={"$(=min([Claim Done Date]))"}>} [Claimant Reserve Payment])

Regards,

Kiran Rokkam.

1 Reply
Not applicable

Re: FirstSortedValue in a Straight Table

If you are using QV11 use dimension limits and show first row.

If not use the following experssion for Reserve

Sum({<[Claim Done Date]={"$(=min([Claim Done Date]))"}>} [Claimant Reserve Payment])

Regards,

Kiran Rokkam.

Community Browser