Discussion Board for collaboration on QlikView Scripting.
I have 1 requirement where i want to pull Top 1 record from minimum created date .
Columns are given below:
I wan to pull 1 row for each Person_wid with Applying logic for Top 1 record from minimum created date.
you can use firstSortedValue()
Can you give me a written script...as i have never used it before...
below example from help menu
LOAD * inline [
] (delimiter is '|');
LOAD Customer,FirstSortedValue(Product, UnitSales) as MyProductWithSmallestOrderByCustomer Resident Temp Group By Customer;
Here there are calculating Customer purchasing product at lowest price.
Firstsortedvalue(distinct ACQ_Source, Created_Date) as ACQ_Source_Min
group by Prospect;
HOw we can perfrom group by using table name like group by Prospect;
group by Person_wid;