Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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....
Hi,
You need to implement the Incremental Logic on this.
Have a look at the link for more info on this.
http://community.qlik.com/docs/DOC-1870
Regards,
Kaushik Solanki