Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Creating New Date Records in Edit Script when Loading


i have a data set as below

Id           Date               count

1            2/10/16               2

2             2/1/16                1

3            5/6/16                 4

I would like my result set as below

Id           Date               count               Week Day(No Required)

1            2/10/16               1

1            2/11/16               1

2            2/01/16               1   

3            5/06/16               1                    Friday    

3            5/09/16               1                    Monday   

3            5/10/16               1                    Tuesday   

3            5/11/16               1                    Wednesday

Note: If the day of the week is Saturday or Sunday in has to skip date and select the next date. Based on the count the records should be created by increment(or adding a new record for same ID but using different date) one day(if it is Sunday or Saturday please pick following Monday as shown in example of ID 3)

Can some one please advise.

Thank You

Community Browser