Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bnelson111
Creator
Creator

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
bnelson111
Creator
Creator
Author

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

bnelson111
Creator
Creator
Author

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".