Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can someone please ppoint where I am going wrong.. I have a QVW file and an NPrint Excel template is setup for the daily and it is working fine. We were working on the same kind of setup but for the last weekend but for some reason it is failing.. attached the error log .. we have 2 separate qvw files and 2 separate connections in nprint and different filters
the only difference Is the filter setup...
for the last weekend I have used date(WeekEnd(Today(),-1,6)',MM/DD/YYYY')
can some one please look at the error and suggest what could be wrong.. attached error log
I am quite sure your issue sits in wrong filter:
read this topic (also check other filter topics on my blog):
https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/
in short: - date filter is numerical value (hence DATE() function should not be used when creating a filter. Additionally using WeekEnd function you are creting a TimeStamp with the hour:minute and a second 23:59:59.... This is standard QlikView/QlikSense knowledge though.
the way a would debug it is:
thanks
Lech
Hi,
There are not attachments. Please add also screenshots of the Task Executions page and the template and filter setups.
Best Regards,
Ruggero
Hi Ruggero,
added all screenshots into one zip file..thanks a lot
I am quite sure your issue sits in wrong filter:
read this topic (also check other filter topics on my blog):
https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/
in short: - date filter is numerical value (hence DATE() function should not be used when creating a filter. Additionally using WeekEnd function you are creting a TimeStamp with the hour:minute and a second 23:59:59.... This is standard QlikView/QlikSense knowledge though.
the way a would debug it is:
thanks
Lech
Thank you Lech,
Really appreciate your help. I used date and floor combined it is working fine - This is working fine
DATE(Floor(WEEKEND(Today(),-1,6)), 'MM/DD/YYYY')