Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
psankepalli
Partner - Creator III
Partner - Creator III

Get the list of applications not used in 30 days

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

PR

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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 SessionsUnique UsersUnique DocsAvg. # SelectionsAvg DurationMBytes Sent + Rec'dSession CallsLast AccessedDays Since Last Session
>=60 days unusedTotal 31996 1018 11 8,8 00:35:05 26557,6 2456321 28-Jan-2016 64
govdb 28 شسيب αδε שגקяиуу.qvw2112,000:36:099,83565-Jan-201687
governance dashboard 2.0.027.qvw15416,000:30:3356,219235-Jan-201687
governance dashboard 2.0.030 for qlikcommunity.qvw41411,500:42:2349,9234926-Jan-201666
governance dashboard 2.0.032.qvw2116,000:31:217,232125-Jan-201667
governance dashboard 2.0.033.qvw15313,100:23:4430,9139326-Jan-201666
governance dashboard 2.0.035.qvw13310,900:35:0818,692028-Jan-201664
movies database.qvw2210,500:15:080,9308-Jan-201684
qlikview developer toolkit.qvw1110,000:30:040,376-Jan-201686
retail store performance.qvw1112,000:30:201,4525-Jan-201687
sales 360.qvw31894100718,800:35:0526378,6244825325-Jan-201667
supermultibyteappشسي.qvw106111,700:23:443,871720-Jan-201672
>=90 days unused1110,000:30:060,0130-Dec-201593
>=150 days unused3315,300:30:481,3946-Oct-2015178

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.

View solution in original post

6 Replies
swuehl
MVP
MVP

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

psankepalli
Partner - Creator III
Partner - Creator III
Author

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

PR

psankepalli
Partner - Creator III
Partner - Creator III
Author

Hi any help from any one..

swuehl
MVP
MVP

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 SessionsUnique UsersUnique DocsAvg. # SelectionsAvg DurationMBytes Sent + Rec'dSession CallsLast AccessedDays Since Last Session
>=60 days unusedTotal 31996 1018 11 8,8 00:35:05 26557,6 2456321 28-Jan-2016 64
govdb 28 شسيب αδε שגקяиуу.qvw2112,000:36:099,83565-Jan-201687
governance dashboard 2.0.027.qvw15416,000:30:3356,219235-Jan-201687
governance dashboard 2.0.030 for qlikcommunity.qvw41411,500:42:2349,9234926-Jan-201666
governance dashboard 2.0.032.qvw2116,000:31:217,232125-Jan-201667
governance dashboard 2.0.033.qvw15313,100:23:4430,9139326-Jan-201666
governance dashboard 2.0.035.qvw13310,900:35:0818,692028-Jan-201664
movies database.qvw2210,500:15:080,9308-Jan-201684
qlikview developer toolkit.qvw1110,000:30:040,376-Jan-201686
retail store performance.qvw1112,000:30:201,4525-Jan-201687
sales 360.qvw31894100718,800:35:0526378,6244825325-Jan-201667
supermultibyteappشسي.qvw106111,700:23:443,871720-Jan-201672
>=90 days unused1110,000:30:060,0130-Dec-201593
>=150 days unused3315,300:30:481,3946-Oct-2015178

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.

psankepalli
Partner - Creator III
Partner - Creator III
Author

Hi Swuehl,

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

Thanks

PR

psankepalli
Partner - Creator III
Partner - Creator III
Author

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

PR