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.
Not applicable

Qlikview Date Looping + Storing looping result

Hi guy,

Im have couple of question here.

First..

For Example:

Customer_ID, Credit_Left , Date To, Date From

C123, 100, 1/6/2011, 2/6/2011
C123,  80,  2/6/2011,11/6/2011
C123, 120, 11/6/2011, 31/12/2011

How do i get the following output result Eg

C123,100,1/6/2011
C123,80,2/6/2011
C123,80,3/6/2011
C123,80,4/6/2011

...........
C123, 120 11/6/2011
C123, 120 12/6/2011
C123,120, 12/6/2011
.......
C123,120 31/6/2011

Second..Izzit possible to store all the looping result into existing database without record duplicate?

The output result i wish to get which is the last day of the month and sum all the Amount from different customer for doing report.

PSmiley Frustrated I got existing table with many attribute also. im just taking out some field for doing report,

Please help me out
Thank You
Regard
Matt

1 Reply
Not applicable

Re: Qlikview Date Looping + Storing looping result

Hi,

Please find the Attached Application which serves  your need.

Community Browser