What am I trying to Achieve?
Deliver Excel Report every night in a network folder by adding data for the previous day and keep accumulate it till the end of the month
And at the beginning of the new Month, nPrinting Will generating similar report for the next month and leave the previous month report as is.
Does it look possible ?
simple solution would be is to enable the dynamic naming of the files in NPrinting ....in the dynamic naming build a file name like Month_name&'-'&file_name so that for the entire month the file will be replaced automatically when it comes to next month since the name of the file is changed Nprinting will automatically creates a new file
Good Idea.. I will create a QlikView Variable as =Month(now());
But how should I accumulate the data in the same file ? should I pass a filter in the report ?
And sorry if I sound dumb.. as I am new to Qlik.. but do you think following would work?
1. Create a Month-to-date variable in Qlik
2. And everynight when data is loaded, it will only load for YTD !
3. and then NPrinting over right the file by using Month name in the dynamic name?
I have tried everything in last 1 hour but unable to achieve the result
I have attached a sample QVD & QVW which I used to test nPrinting
It did not work
1. Same Qlikview Variable
2. Created Filter in NPrinting for the field name '[Order Date]' with value as 'Month(Today())
Still did not work.
Am I doing anything wrong or is it never gonna be possible ?
Expected published report : Should only show data for month of April