How to find immediate and immediate-1 Dates in Qlikview if i am getting random dates in data
I have requirement to find out immediate and immediate-1 Dates in Qlikview if i am getting random dates.
For Example: I have fields MaterialID ,Batch_0,Vigor%,VigorTestDate,Germination%,GerminationTestDate and i am getting random date.
i have requirement to find out VigorTestDate and GerminationTestDate Immediate and Immediate -1 dates on basic of Batch selection that means if i select batch 11 then in VigorTestDate i want 17-07-2017 and 15-03-2016 and in GerminationTestDate i want 26-09-2017 and 22-08-2017.
i have attached sample application also for reference
i want solution how i can achieve this in backed and front end as well
Note :I am using personal edition of Qlikview so please post sample solution in notepad so i can view solution and implement same in my Qlikview .