Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

Avg Logging Time calculation

Hi All,

iam adding new visualizations in existing  Qliksense operations monitoring app, required your suggestions or inputs to derive certain kpi's , i want to calculate  Daily Avg Logging time ,we have Log Entry Period Start  and  Log Timestamp fields in Log Content table,  are those to be used to achieve the kpi? how do i achieve it ? and also what is the difference between Logging time & Session time in context of Qliksense environment?

5 Replies
YoussefBelloum
Esteemed Contributor

Re: Avg Looging Time calculation

Hi,

don't know what is the fields you can use and what type of Kpi's you need exactly.. but it is clear that you will have to calculate the difference between two timestamp fields.

you will need to evaluate your fields using Timestamp#()

and then calculating the difference of time using Interval()

like this:

Interval(Timestamp#(....) - Timestamp#(....),'the format you need')

Partner
Partner

Re: Avg Logging Time calculation

Hi Youssef,

Thanks for the response,  i want to calculate the average logging time by users in Qliksense operational monitoring app which collects all the log information. but above expression was not working if iam using in KPI object

YoussefBelloum
Esteemed Contributor

Re: Avg Logging Time calculation

If you make some selections on the Log Id it works?

you need to have an aggregated view ? or by Log Id after selections ?

Partner
Partner

Re: Avg Logging Time calculation

i need to show this avg logging time as kpi object as aggregated value

YoussefBelloum
Esteemed Contributor

Re: Avg Logging Time calculation

try nested aggregation using Aggr() outside of the existing expression, aggregating on the Log Id field for example

like this:

=AGGR(your_expression,LOF_ID_FIELD)