Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table like one shown below
I want to find first Row of T2 for each T1 as shown below. Please help.
I tried using first sorted value but I was not able to write.
could someone please help me.
Thanks in advance.
Check with the FirstValue and LastValue functionality to get first and last values.
FirstValue(T3) AS T3,
FirstValue(T2) AS T2
Group By T1;
Hope it helps