Discussion Board for collaboration on QlikView Scripting.
in the above table
in Text field test1 is the earliest value of ID 100,
test5 is the earliest value of ID 200,test7 is the earliest value of ID 300,
we need to show earliest values for the above IDs as a reult.:
Could u pls help me to get the below result:
How do you determine earliest value? Your Date values are the same per ID.
If you are referring to the first record in your table per ID, try
ID, FirstValue(Name) as Name, FirstValue(Date) as Date, FirstValue(Text) as Text
GROUP BY ID;
DROP TABLE YourTable;
It looks like you need to aggregate your data with the GROUP BY load. SOmething like this:
You may have to sort your data in the desired order before grouping, or play with the optional sort-weight parameter of the FirstSortedValue() function.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!
Check out my book QlikView Your Business - an Expert Guide to QlikView and Qlik Sense