topic Re: Audit Data changes or Updates. in QlikView

Audit Data changes or Updates.

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

I have a Qlikview presentation that measures the sales orders loaded by person by customer by date. Recently we have notice updates on the data in that if a user on the MIS database updates a sales order their name is then tagged to the sales order (OurContact as loadedby) and the original person losses the credit for the initially raised order.

So in basic terms. I could raise a order and have 10 orders in April accounted to me and if a colleague updates one off them he or she then has 1 order and i have 9 (OurContact as loadedby). I would like a way to see these changes based on each time the script is refreshed.

We unfortunately do not have a audit function on our MIS system.

Any ideas?

Thanks in advance

Brett

Below is the script.

LOAD

SOrderNum,

SOrderDate,

month(SOrderDate) as MonthSalesOrderLoaded,

Year(SOrderDate) as YearSalesOrderLoaded,

OurContact as loadedby,

CustCode;

SQL SELECT *

FROM PUB."PV_SOrder"

WHERE (SOrderDate > '$(varMaxDate)') ;

[Customer Name]:

LOAD CustCode,

CustName;

SQL SELECT CustCode,

CustName

FROM PUB."PV_Customer";

Re: Audit Data changes or Updates.

kaushiknsolanki — Mon, 01 May 2017 09:39:29 GMT

Hi,

This is similar to what we call as SCD (Slowly Changing Dimension)

Have a look at the link below to understand this in details with how to use it in Qlik.

Slowly Changing Dimensions

Regards,

Kaushik Solanki

Re: Audit Data changes or Updates.

bnelson111 — Mon, 01 May 2017 11:06:47 GMT

How do i write in my original script the previous value?

Re: Audit Data changes or Updates.

bnelson111 — Tue, 02 May 2017 14:57:16 GMT

Still need help

Re: Audit Data changes or Updates.

kaushiknsolanki — Tue, 02 May 2017 16:40:43 GMT

Hi Brett,

I hope you have seen the links I had given.

If you are clear then can you explain in detail what you want with example.

Regards,

Kaushik Solanki