Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bnelson111
Contributor

Audit Data changes or Updates.

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

4 Replies
Highlighted

Re: Audit Data changes or Updates.

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
Contributor

Re: Audit Data changes or Updates.

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

bnelson111
Contributor

Re: Audit Data changes or Updates.

Still need help

Re: Audit Data changes or Updates.

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

Community Browser