Qlik Community

Qlik Sense App Development

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

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion
Champion

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

Highlighted
Partner
Partner

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

Highlighted
Champion
Champion

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

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

Highlighted
Partner
Partner

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

Highlighted
Champion
Champion

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)