topic Re: Set analysis - last run date for user statistics in QlikView

Set analysis - last run date for user statistics

Fri, 19 Dec 2014 15:14:09 GMT

Hi everyone,

I'm creating a dashboard which shows the user statistics for our suite of BI reports. I want to decommission reports which haven't been used this year and show a list of the reports in a straight table like this:-

I have written the following set analysis: =Max({<FinancialYear-={'2014-2015'}>}ReportDate)

This is showing the last time it was run before this year and so heavy duty (recently run) reports are coming up with 31/03/2014 as the last run date when I want to show the last time it was run not including any which may have been run in 2014/15. I hope that makes sense?!

Is what I want to show acheivable with set analysis? Where am I going wrong?

Thanks for any help you can give

Natalie xXx

Re: Set analysis - last run date for user statistics

Gysbert_Wassenaar — Fri, 19 Dec 2014 15:24:25 GMT

Maybe like this:

=Max({<ReportName=E({<FinancialYear={'2014-2015'}>}ReportName)>} ReportDate)

If not, then please post a document that demonstrates the problem.

Re: Set analysis - last run date for user statistics

Anonymous — Fri, 19 Dec 2014 15:45:15 GMT

Hi,

try:

=Max({<FinancialYear={'<2014'}>}ReportDate)

Re: Set analysis - last run date for user statistics

Mon, 22 Dec 2014 10:59:32 GMT

Morning

Thank you for your responses but neither of those have worked and I can't attach a document as it's on our server and doesn't have an URL.