Generate KPI trends from LoadDate

[DD-44]

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:

• number of non-compliant hosts
• number of non-compliant accounts

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.

[jwjackso · Accepted solution]

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);

[DD-44]

Thank you!