Audit Data changes or Updates.

[bnelson111]

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";

[kaushiknsolanki]

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

Slowly Changing Dimensions

Regards,

Kaushik Solanki

[bnelson111]

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

[bnelson111]

Still need help

[kaushiknsolanki]

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