Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

Hi any help from any one..

Highlighted
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

Highlighted
Partner
Partner

Hi Swuehl,

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

Thanks

PR

Highlighted
Partner
Partner

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