Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have request from warehouse manager, she wants to know the returns of goods from customers , weekly delivered to her from nprinting excel report. I have got the data in SQL , database update every day. I have made the query contains what columns are required , went to qlikview made connection , and pasted it . I have made report, what shall i do now if she wants to get it every week report . how to write expression or do i have to do it in QMC for reports to be delivered weekly.
Hi Giridhar,
In my opinion your question is rather organizational. You need to solve the problem with your chief - what information and in what form you can provide the warehouse manager.
Regards,
Andrey
step 1: u have to pull only one week data at a time by writing logic in ur where clause of edit script (from today date - 7).
step 2: schedule ur report to share with customer on weekly basis once data was refreshed on step 1.