Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qv_jagan
Contributor

First Sorted Value

I have a table like one shown below

T1T3T2
AA0
AB1
AA2
BB2
BA1
BB0
CA1
CB2
CA3
DB1
EA1
EB0
FA1
FB1
GA2


I want to find first Row of T2 for each T1 as shown below. Please help.

T1T3T2
AA0
BB2
CA1
DB1
EA1
EB0
FA1
GA2

I tried using first sorted value but I was not able to write.

could someone please help me.

Thanks in advance.

1 Reply

Re: First Sorted Value

Hi,

Check with the FirstValue and LastValue functionality to get first and last values.

Load

     T1,

     FirstValue(T3) AS T3,

     FirstValue(T2) AS T2

Resident TableName

Group By T1;

Hope it helps

Community Browser