Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thewillemzelluf
New Contributor II

changing dimensions

Hello everyone,

I have a question about dimensions that change. The fact is that when an order is received it is placed in the order table. When this order is finally sold (turnover), the amount in the order table goes to 0 and in the sales table to the order quantity. The number + amount therefore jumps from order.table to turnover.table.

However, this means that I can not see what was in the order table last year because it is now in the revenue table. Does anyone have any idea how I can store it so that I can still find out?

Thanks in advance!

Tags (1)
1 Solution

Accepted Solutions

Re: changing dimensions

Hi,

See SCD-2 in google.

You have to implement to track changes in table. You can implement it in either dataware house or in QVD

IN QVD not recommended because size of qvd will start getting increase day by day.

Regards

Regards,
Prashant Sangle
2 Replies
ogster1974
Honored Contributor II

Re: changing dimensions

I would suggest you look at storing your orders in a QVD and break your load up into an incremental load.

INSERT

UPDATE

DELETE

That way you can check for orders being zeroed out and exclude from the UPDATE.

Hope this helps

Regards

Andy

Re: changing dimensions

Hi,

See SCD-2 in google.

You have to implement to track changes in table. You can implement it in either dataware house or in QVD

IN QVD not recommended because size of qvd will start getting increase day by day.

Regards

Regards,
Prashant Sangle