Discussion board where members can get started with QlikView.
I have a file that is ingested into QlikView, gets its date from the filename and the other object I require are Comments.
date(subfield(FileName(), '-', 1), 'DD/MM/YYYY') as Vuln_Date
Vuln_Date as %Calendar
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.