Discussion Board for collaboration related to QlikView App Development.
I have Batch date from script but I want to pull latest date from script depending upon current selection. Please refer the following ex:
|Header 1||Header 2||Header 3||Header 4|
In above example : MATNR 1: I have 3 keys and 3 dates but with same qty. Now In calender I have selcted 2015 Apr.
So in that case I want only 1 row that is last row as it is nearer to my selection date.
How to handle this in script side only, so How to write a script for that.
Current selections are not available during the load. So there are no current selections that can be used in the script.
use below script it will give max date
max(BatchDate) as BatchDate resident table group byMATNR,Qty;
and let me know if it is working or not or else provide data
Another method to fetch the min/max value from a field: “Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook.
It will work for irrespectiove of current selection.
It means in your solution it will give me 25 Apr 2015 but if i select Jan 2015 then in that case I want first record i.e,
22 Jan 2015