maintain history table

Mon, 15 Apr 2013 05:22:31 GMT

AOA grus.

I have a table of current stock in my database

which load in qlikveiw through qvd file

L_C_STOCK:

sql select

part_no,

stock_code,

store_code,

location_id,

qty_in_stock

from "STORE_DB"."L_C_STOCK";

STORE L_C_STOCK INTO L_C_STOCK.QVD(QVD);

NOW FOR LOADING

L_C_STOCK:

LOAD

part_no,

stock_code,

store_code,

location_id,

qty_in_stock

from (QVD);

above table has data of current time (current time means time when we load qvd from database)

and on the seecond time when we load qvd old data will be overwritten with new one)

e.g

let suppose we load qvd on 28 FEB 2013 and data like

part_no	stock_code	store_code	location_id	qty in stock
12-12-255-1	IT	2	KKK	10
11-13-222-2	MAINT	1	GGG	15

now when we load on 30 March 2013 new data was like that.....

part_no	stock_code	store_code	location_id	qty in stock
12-12-255-1	IT	2	KKK	18
11-13-222-2	MAINT	1	GGG	7

so there is no way to find change in qty btween 28 feb and 30 april

what should i do to maintain history in qlikview i dnt want to change the structure of my database....

Re: maintain history table

kaushiknsolanki — Mon, 15 Apr 2013 07:18:34 GMT

Hi,

You need to implement the Incremental Logic on this.

Have a look at the link for more info on this.

Regards,

Kaushik Solanki