topic Re: Get the list of applications not used in 30 days in QlikView

Get the list of applications not used in 30 days

psankepalli — Fri, 01 Apr 2016 16:06:55 GMT

Hi,

I want a list of applications which are not used/opened in last 30 days and 30 -60 days from QVS. How do I get that list.

Please advice

Thanks

Re: Get the list of applications not used in 30 days

swuehl — Fri, 01 Apr 2016 16:08:24 GMT

Have a look into the governance dashboard, this information should be available there (or it should be easy to create a chart based on its data model).

Re: Get the list of applications not used in 30 days

psankepalli — Fri, 01 Apr 2016 17:46:47 GMT

Hi Swuehl,

I checked on Givernance dashboard, it has applications based on last usage. but My requirement is I want to list of application which are not used in the 30 days frame & 30-60 days frame.

please give a logic how to get that

Thanks

Re: Get the list of applications not used in 30 days

psankepalli — Mon, 04 Apr 2016 00:07:07 GMT

Hi any help from any one..

Re: Get the list of applications not used in 30 days

swuehl — Mon, 04 Apr 2016 00:29:07 GMT

Well, the data is already there in the governance dashboard.

You just need to modify the graph to group by unused time period, maybe similar to this:

=Aggr('>=' &Floor(Today()-max(daystart(Session_Start)),30) &' days unused',DocName)	Doc	Sessions	Unique Users	Unique Docs	Avg. # Selections	Avg Duration	MBytes Sent + Rec'd	Session Calls	Last Accessed	Days Since Last Session
>=60 days unused	Total	31996	1018	11	8,8	00:35:05	26557,6	2456321	28-Jan-2016	64
	govdb 28 شسيب αδε שגקяиуу.qvw	2	1	1	2,0	00:36:09	9,8	356	5-Jan-2016	87
	governance dashboard 2.0.027.qvw	15	4	1	6,0	00:30:33	56,2	1923	5-Jan-2016	87
	governance dashboard 2.0.030 for qlikcommunity.qvw	41	4	1	1,5	00:42:23	49,9	2349	26-Jan-2016	66
	governance dashboard 2.0.032.qvw	2	1	1	6,0	00:31:21	7,2	321	25-Jan-2016	67
	governance dashboard 2.0.033.qvw	15	3	1	3,1	00:23:44	30,9	1393	26-Jan-2016	66
	governance dashboard 2.0.035.qvw	13	3	1	0,9	00:35:08	18,6	920	28-Jan-2016	64
	movies database.qvw	2	2	1	0,5	00:15:08	0,9	30	8-Jan-2016	84
	qlikview developer toolkit.qvw	1	1	1	0,0	00:30:04	0,3	7	6-Jan-2016	86
	retail store performance.qvw	1	1	1	2,0	00:30:20	1,4	52	5-Jan-2016	87
	sales 360.qvw	31894	1007	1	8,8	00:35:05	26378,6	2448253	25-Jan-2016	67
	supermultibyteappشسي.qvw	10	6	1	11,7	00:23:44	3,8	717	20-Jan-2016	72
>=90 days unused		1	1	1	0,0	00:30:06	0,0	1	30-Dec-2015	93
>=150 days unused		3	3	1	5,3	00:30:48	1,3	94	6-Oct-2015	178

So I've just added a calculated dimension

=Aggr('>=' &Floor(Today()-max(daystart(Session_Start)),30) &' days unused',DocName)

to the usage detail graph.

Adapt to your needs.

Re: Get the list of applications not used in 30 days

psankepalli — Mon, 04 Apr 2016 03:20:47 GMT

Hi Swuehl,

Thank you for your help. I will work on this.

Thanks

Re: Get the list of applications not used in 30 days

psankepalli — Tue, 05 Apr 2016 04:53:12 GMT

Hi Swuehl,

this logic worked as expected. thank you very much for your help.

=Aggr('>=' &Floor(Today()-max(daystart(Session_Start)),30) &' days unused',DocName)

Thanks