Discussion Board for collaboration on QlikView Scripting.
T1 has got multiple entries when I added the new field Text to it.
I would like to display a sigle entry which have the value for the field Text for each PID like below.
Help me to get the below output:
(html, codepage is 1252, embedded labels, table is @1);
Only(Name) as Name,
Only(Status) as Status,
Only(Date) as Date,
FirstValue(Text) as Text
Group By PID
Order By PID, Text desc;
DROP Table Table;
Can You please get same in front end
Create a straight table with:
Dimension: PID, Name, Status, Date