Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a straight table with content as shown below
I would like to keep only one row for each CID, i.e the latest row of data.
Can someone please let me know how to do this in the front end and not in the script?
Go to Solution.
You can try using FirstSortedValue() function : FirstSortedValue(CID, StartDate).
let me know if that doesnt work
Razor , While leading the data, just load the data what you need.
Max(StartDate) AS StartDate
Group By CID;
The above script keeps only latest record CID based on StartDate.
You could work with max()
Taking CID, LID, Desc and StartDate as Dimensions and max(EndDate) as expression ends up in a straight table just holding the values of the latest EndDate.
That's working now. Thanks to everyone, especially Krishna and Massimo