Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bobbydave
Contributor III

Update comment to show in report

Quick synopsis.

I have a report that I ingest into QlikView each week on a Monday e.g . 11/02/2019. This then creates a NPrinting report. Within this report are two blank column called Action Status and Comment. Users fill these in. This then is fed back into QlikView with the Comments and Action Status on a Friday 15/02/2019 and concatenated to the original QVD.

My problem is the following Monday. When I look at the week max(date), I don't see in the QVD that the Comments and Action Status have been updated.

 

Code below

[Comment]:
LOAD %Vulnerability,  
     Description, 
     Hostname, 
     Owner, 
     [Switched On],
     App, 
     [IP Address], 
     [First Detected], 
     [Last Detected], 
     [Remediation Date], 
     Severity, 
     [Upper Time Limit (Days)], 
     [CVSS Value], 
     DNS, 
     NetBIOS, 
     [Tracking Method], 
     [IP Status], 
     QID, 
     Title, 
     [Vuln Status], 
     Type, 
     Threat, 
     Impact, 
     Solution, 
     Exploitability, 
     Category, 
     [Action Status], 
     Comment,
     Date(Date#(left(SubField(FileName(), ' ', -1),10), 'YYYY-MM-DD'), 'DD/MM/YYYY') AS [Vulnerability Date]  
FROM
[$(vReport)\Vulnerability_Tracker *.xlsx]
(ooxml, embedded labels, table is Vulnerability_Tracker)where Comment <> NULL();

Concatenate

LOAD %Vulnerability, 
     Description, 
     Hostname, 
     Owner, 
     [Switched On],
     APP, 
     [IP Address], 
     [First Detected], 
     [Last Detected], 
     [Remediation Date], 
     Severity, 
     [Upper Time Limit (Days)], 
     [CVSS Value], 
     DNS, 
     NetBIOS, 
     [Tracking Method], 
     [IP Status], 
     QID, 
     Title, 
     [Vuln Status], 
     Type, 
     Threat, 
     Impact, 
     Solution, 
     Exploitability, 
     Category, 
     [Action Status], 
     Comment, 
     [Vulnerability Date]
FROM
[$(vQVDs)\Qualys.qvd]
(qvd) where not  Exists (%Vulnerability);

Store Comment into $(vQVDs)\Qualys.qvd;
//drop Table Comment;

KeyTable:
LOAD
	 %Vulnerability,
	 [Vulnerability Date] 										as %Calendar

Resident Comment;


Any reason why my comments and action status would not show up on the report.

The other thing is users will update comments during the following weeks NPrinting so it will append to the Comments and Action Status.

 

Please help. Last part of the project to get working.