I have historical data that never changes. Currently I load into Qlikview like this:
LOAD record1, record 2, record3,...,recordn, date;
SQL SELECT record1, record 2, record3,...,recordn, date from MySQLTable WHERE record1 = X;
STORE MySQL Table into \file\;
I use this format for several sql select statements. I want to be able to have this data stay in qlikview (or qvd) and then just append one day's data at the end of the day. Can I do this without having to reload all the data? If I do how do I write it and if I don't also how do I write it? Do I have to make another tab or can I keep it in this tab?
I am not even sure I am using the .qvd STORE correctly and for its intended purpose - any thoughts? Thanks!