Discussion Board for collaboration on QlikView Scripting.
Im have couple of question here.
Customer_ID, Credit_Left , Date To, Date From
C123, 100, 1/6/2011, 2/6/2011C123, 80, 2/6/2011,11/6/2011C123, 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/2011C123, 120 12/6/2011C123,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.
P I got existing table with many attribute also. im just taking out some field for doing report,
Please help me outThank YouRegardMatt
Please find the Attached Application which serves your need.