This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi Steive ,
Please check below link
Thanks i will try this. The other question i had was - how do i create the history data to monthly QVD files. For instance, how do i create the loop to look at the history and export month by month to qvds for 4 years.
Will this script work for that?
MyQvd:LOAD *, Date(Date,'YYYYMM') as YearMonth FROMsource.qvd(qvd);Temp:Load Distinct YearMonthResident Temp;let Vm=NoOfRows('Temp');for I=0 to $(Vm)-1;LET vFileName=Peek('YearMonth',$(I),'Temp');Table:
NoConcatenateLoad * resident MyQvdwhere YearMonth = '$(vFileName)';STORE Table into $(vFileName).qvd (qvd);
drop table Table;NEXT I;DROP Table Temp, MyQvd;
Creating Daywise QVDs
Using this you can create the day wise qvds and further you can create the Monthly qvds using daily qvds
Is it possible to do this from the SQL DB and not from a QVD - so far i can only see how people do it from existing QVD's, i want to it from the DB