Save and update

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have below table which keeps relaoding into the Qlikview trhough DB . in this we have some key fields , like pics and Pro some times there will be change of the status which i wont come to know , always when the table reloads it comes with the current data .

Is there a way wehere i can have the historical data stored in qlikview ? where i can show that when was the ticket exisiting and when ig got removed?

Ticket	Prics	Pro	Date
AA1	7	avtive	12-Mar-20
AB1	45	passed	13-Mar-20
AC2	12	passed	14-Mar-20
AE3	12	failed	15-Mar-20
AD5	13	passed	16-Mar-20
AE7	12	active	17-Mar-20
AZ2	5	progress	18-Mar-20

Thanks in Advance

Re: Save and update

Brett_Bleess — Tue, 21 Apr 2020 20:20:11 GMT

Only way of which I can think to do that is two separate data models in the application, one for the pre-current load and one for the current load so you would be able to do your comparisons, but I am not sure how the heck you do the swap, I guess on each load you would first need to load that prior QVD you created into the pre-current model and then do your pull from the DB and create new QVD etc... I am sure there are likely better options, but only one of which I can think.

I had another idea, but I got interrupted and it went right out of my head, and I cannot think of it again, sorry. Oh, I know what it was, maybe using a flag field of some sort to keep track of the historical versus current records, so when you reload the history files, you set a flag to true, but when you pull the records from the DB, you leave that flag false, that gives you a way in a single data model to keep things segregated I think. That is likely the best approach I think rather than trying to do two data models. Hopefully this gets you on a decent path forward.

You can do a search on 'flag' in the following link to have a look at some ideas on how this is used in some situations, not sure we have one that directly correlates to yours, but hopefully it may help further:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Re: Save and update in QlikView

Save and update

Re: Save and update