topic Re: Limit date ranges without changing the model in QlikView

Limit date ranges without changing the model

Anonymous — Wed, 14 Oct 2015 20:30:14 GMT

Hello,

Is there a way to limit data to a specific range without editing the model we're using or dropping/re-adding tables on the dashboard?

For example:

The data in my model contains data through Oct. 1. This is fine for most dashboards, however, is it possible to limit data within dashboards to only show data through July 1?

I'm using a binary load in my dashboards to load the model with a separate master calendar in each dashboard.

Thank you in advance!

Re: Limit date ranges without changing the model

Anonymous — Wed, 14 Oct 2015 20:33:38 GMT

if you use set Analysis you can deine other date ranges as well

sum({<mydate={'<=July 1'}>}value

you Need to define your proper fields out of your data model

Re: Limit date ranges without changing the model

crystles — Wed, 14 Oct 2015 20:35:34 GMT

If you have a separate master calendar with each dashboard, you can simply put a where clause at the end of the master calendar load to limit the dates being pulled.

Re: Limit date ranges without changing the model

Anonymous — Wed, 14 Oct 2015 23:54:35 GMT

Is there a reason that you can't just make selections?

Re: Limit date ranges without changing the model

Anonymous — Thu, 15 Oct 2015 13:30:11 GMT

Some of the data in the model is refreshed quarterly and other data is updated weekly. These tables all link together but there are holes when use data from the quarterly updated tables since the data, from the tables that are updated weekly, have nothing to link to in the quarterly updated tables.

Re: Limit date ranges without changing the model

Anonymous — Thu, 15 Oct 2015 13:31:29 GMT

Thank for your reply crystles. This has been attempted and works to a point, however, the data is still able to be filtered outside of the master calendar date range

Re: Limit date ranges without changing the model

crystles — Thu, 15 Oct 2015 13:54:55 GMT

So are the weeks that are being loaded, outside of the quarters that are being loaded? It seems each week would belong to a quarter. And if the quarters are loaded first, then the weeks would belong to the quarters that are already loaded?