Update Comment

bobbydave — Sat, 16 Nov 2024 21:18:52 GMT

Hi,

I have a file that is ingested into QlikView, gets its date from the filename and the other object I require are Comments.

Vuln:

Load

%Vulnerability,

Comment,

date(subfield(FileName(), '-', 1), 'DD/MM/YYYY') as Vuln_Date

from file_*.xlsx

KeyTable:

Load %Vulnerability,

Vuln_Date as %Calendar

Resident Vuln;

Store Vuln in Qvd

What I want to do is to load Comment for this month and if the Comment next week is empty, use the previous weeks comment and for it to remain until the newest file has new comment.

When a new file comes in, if the %Vulnerability in the new sheet is not there, then the going to be no comment.

topic Update Comment in QlikView

Update Comment