topic Re: Filtering for just one month in a table in QlikView

Filtering for just one month in a table

Tue, 21 Apr 2015 15:52:34 GMT

Hi,

On my dashobard I have a years worth of data on various tables and charts, however for one part of the dashboard i just want to be able to show the previous months month end figures, doesnt matter what filters are used, it just always needs to show last month.

I have a box for total patients, total waiting over 18 weeks and % compliance. An example of my calcualtion/formular is:

= sum({$<Metric_Part={'Den'}, Metric_Code={'RTT15'}>} Metric_Value)

What would i change to make it show just last month and not the whole year as a total?

Thanks,

Re: Filtering for just one month in a table

ramoncova06 — Tue, 21 Apr 2015 16:03:25 GMT

= sum({$<Metric_Part={'Den'}, Metric_Code={'RTT15'}, Date = "$(=date(floor(monthend(max(Month),-1))))"}>} Metric_Value)

this will give you the for month end of the previous month

Re: Filtering for just one month in a table

Wed, 22 Apr 2015 12:10:06 GMT

Thanks – its giving me an error though. Do I need to change anything in the below formula? Like ‘Date’ does that need to be one of our date fields?

Kate Hunter

Senior Information Analyst

Planned Care Team

Derby Hospitals NHS Foundation Trust

Level 5

Tel: 01332 786745

Ext: 86745