Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
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.
gouthamkk
Contributor

Creating New Date Records in Edit Script when Loading

HI,

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