Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bobbydave
Contributor III

Update Comment

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.

Labels (2)