Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have recently taken over the ownership on a set of QlikView dashboards that run from a master calendar script with EngineDate - which QlikView has assigned a synthetic key to.
Load
Min(EngineDate) as minDate,
Max(EngineDate) as maxDate
This is fine for adding multi-box filters to graphs that have related engine data in them, however, I want to add multi box filters that don't contain EngineDate information, these additional graphs represent something different.
Is there an easy way of doing this?
Thanks,
Ruth
Do you mean you have multiple date fields? and you want a single way of filtering.
check canonical date concept.
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
Hi,
I have multiple graphs, which I want to filter the data on, year/month/quarter etc. However, how the multi-box filter is set-up at the moment, I can only filter graphs that align to anything related to Engine Date, as this is the date range the master calendar is pointing at.
For the other graphs, that don't contain any engine data, I want to filter on different months/years, but the multi-box option won't let me select anything else. I think I need to set-up a separate master calendar so I can apply filters to these other graphs within the dashboard view?
Thanks for your help,
Ruth
That is the canonical date concept.
once you implement you could set the filters from the CanonicalCalendar.
You will need to setup your visualizations appropriately as well.
check the link i shared it goes in good detail
Hi,
Thanks for getting back to me
I have had a look at your previous post in relation to a CanonicalCalendar. I can definitely see how this would be really beneficial. However, when looking at what has previously been set-up in the QlikView dashboard I have taken over, there is no table for the master calendar that is used. It's loaded purely from script using Engine Date, this only allows me to filter graphs and views where engine score data is used, script is below:
The other link you likely need is the following:
https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527
Here is the base URL in case you need to do further searching in the future:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett