Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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)