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.