topic Re: Weekly Report in QlikView

Weekly Report

ngreddy1982 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Weekly Report

ahaahaaha — Mon, 03 Apr 2017 12:33:41 GMT

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

Re: Weekly Report

buzzy996 — Mon, 03 Apr 2017 12:40:02 GMT

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.