topic Re: Keep records in QlikView

Keep records

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

Hi All,

I have table called jira which has below mentioned fields in the screenshot . So the field "Status and Comments" will keep updating and it will change . But My requirment is to keep the status and Comments as it was before. how can i achive this ?

Can you please help on this how to achive ?

Re: Keep records

MayilVahanan — Mon, 02 Nov 2020 11:32:16 GMT

HI @smilingjohn

We can store the current values in qvd and append the future values in the same qvd instead of replace from the source table.

So that, we can see all the current & future comments in the qvd.

Re: Keep records

smilingjohn — Mon, 02 Nov 2020 11:38:49 GMT

@MayilVahanan Thnaks ,

But how should we do it in the script ? can you please give me a example on this , It would be really helpful .

Re: Keep records

smilingjohn — Mon, 02 Nov 2020 18:00:06 GMT

Hi community

Any help on this

Re: Keep records

MayilVahanan — Tue, 03 Nov 2020 01:10:48 GMT

Hi @smilingjohn

Sample Script:

If not Isnull(QvdCreateTime('T1.qvd')) then
Load * from T1.qvd(qvd);
ENDIF

T1:
LOAD *
FROM
Sourcetable;

store T1 into T1.qvd;

it will concatenate all the source values in to QVD each times of reload the values.
You can change the script based on ur business logic.