Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
swatitomar
Contributor III
Contributor III

How to use Peek in concept

Hi Team,

Need to generate the Max Date in script from below table by creating the new field on the basis of resource wise Min Date.

Input table

ResourceMin Date(dd/mm/yyyy)Program
R11/07/2018P1
R18/07/2018P2
R110/08/2018P3
P202/08/2018P1
S103/07/2018P2
S103/07/2018P3

Output table

Creating max field with 1.

peek () -1 i.e 2nd date minus 1 day and

2. if resource no next record then add 3 months to it I. E. R1 with 10/08/2018 is last record that's y we add 3 months to it .

3. If resource with same min date dn add 3 month's to both of it as done for S1

ResourceMin Date(dd/mm/yyyy)ProgramMax date
R11/07/2018P17/07/2018
R18/07/2018P24/08/2018
R15/08/2018P49/08/2018
R110/08/2018P3 10/11/2018
W202/08/2018P102/11/2018
S103/07/2018P203/10/2018
S103/07/2018P303/10/2018

Hopefully i'm able explain it ..after this i need to incorporate calendar with interval match min max date .

Thanks in Advance!

0 Replies