Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
abdulaziz
New Contributor II

create new table from record

Hi all

I have a table from google calendar. 

it's like

eventfromto
new year28/12/20181/1/2019
A11/11/201811/11/2018
B1/10/20182/10/2018

and I want to make like a calendar for integration with my calendar in QlikView

eventDate
new year28/12/2018
new year29/12/2018
new year30/12/2018
new year31/12/2018
new year1/1/2019
A11/11/2018
B1/10/2018
B2/10/2018

Can someone help me to make it in the script?

1 Solution

Accepted Solutions
MVP
MVP

Re: create new table from record

Use a WHILE loop in your LOAD statement.

Have a look at

Creating Reference Dates for Intervals

View solution in original post

2 Replies
MVP
MVP

Re: create new table from record

Use a WHILE loop in your LOAD statement.

Have a look at

Creating Reference Dates for Intervals

View solution in original post

abdulaziz
New Contributor II

Re: create new table from record

I think you mean IterNo with While

I try this in the link and its work well

many thanks

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctio...