How do you use one date filter without it reducing the data set based on a different date filter?

[ScottDirienzo]

Hi,

I have a QV dashboard that displays the usage of files that are found on a website. There is currently a month filter on the dashboard, where selecting one month or multiple months will show you only the usage of the files that occurred in those selected months. Lets call this 'Usage Month'. This filter is driven by a field called 'Log Date'.

I want to now add another filter called "Import Month', which will be driven by an Import Date field. Selecting a month from this filter should show you only the files that were imported in that selected month. The catch here is that I still want it to show the usage of those files for all time, not just that month it was imported in.

The way I have it setup, if I select May 2019 as the Import month it is successfully only showing me the files imported in May 2019, however it is also only showing me the usage of those files from May 2019. I want it to show the usage of those files from May 2019 to present.

This is the expression I used to bring in the Import Date:

(Date(monthstart(ImportDate), 'MMM-YY')) as ImportMonthYear

Any help would be greatly appreciated. If you need any additional information I will gladly provide it as well.

Thank you!

[ScottDirienzo]

Bump. I can usually find Qlikview answers using Google, but this particular one is so specific and hard to explain that I'm having no luck! I could really use an experts help 🙂

[Brett_Bleess]

Best I have is the following:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Not sure if that is going to work or not, suggest you search directly in the Design Blog area if you have not, as there may be some other posts there that may be closer to what you want, here is generic link to where you can search:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett