Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a simple app to monitor some metrics for an internal IT compliance process.
we have few fields like HOSTs, Accounts, Group and region - (no dates in the dataset)
and my KPIs are:
What I'm looking to do is create a table/QVD with the weekly status of these KPIs, as they periodically change.
With that, I'm looking to verify the trend over time.
I plan to request to QLIK enterprise team to set a periodic load of my data, to have this KPIs generated.
thanks in advance.
KPI:
load [number of non-compliant hosts],
[number of non-compliant accounts],
today() as [load date];
SQL Select * from your data source;
If QvdCreateTime (KPI.QVD) != Null() Then
Concatenate
load * from KPI.QVD;
End If
Store KPI into KPI.QVD (qvd);
KPI:
load [number of non-compliant hosts],
[number of non-compliant accounts],
today() as [load date];
SQL Select * from your data source;
If QvdCreateTime (KPI.QVD) != Null() Then
Concatenate
load * from KPI.QVD;
End If
Store KPI into KPI.QVD (qvd);
Thank you!