topic Re: Dynamic Filters in QlikView

Dynamic Filters

Sat, 18 Oct 2014 17:37:07 GMT

I need to give my users a choice between Received Date and Discharge Date. Once they choose, I want to make all of my Calendar Objects reflect their date choice. Any suggestions?

Re: Dynamic Filters

kuba_michalik — Sat, 18 Oct 2014 20:34:35 GMT

I'd create a variable to store which date is selected, buttons for switching between them (the button Action would be changing the value of this variable), and creating calendar objects for each date, which would be identical in layout and placement, but with a Conditional Show under Properties:Layout which would show only one type of calendar objects depending on which was chosen by the user (based on the variable value).

Re: Dynamic Filters

Sat, 18 Oct 2014 22:08:58 GMT

I don't suppose you could add a little technical "how-to" in there? I understand the concept, but I don't know how to create a variable.

Re: Dynamic Filters

MarcoWedel — Sat, 18 Oct 2014 22:49:33 GMT

Hi,

maybe you could create a canoncial date calendar like described here http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

by Henric Cronström

hope this helps

regards

Marco

Re: Dynamic Filters

kuba_michalik — Sat, 18 Oct 2014 22:52:36 GMT

Sure, no problem. To create the variable, Settings: Variable Overview, and then Add Variable.

For the buttons, under Actions, choose Add, then External, then Set Variable. Input the name of your newly created variable and some value (it can be whatever you want, you just have to distinguish the two date types somehow. First button must set it to one value, the second button must set it to the other value).

Finally, for the objects themselves, in their Properties under Layout change Show from Alway to Conditional, and put a simple condition like this:

your variable name = your variable value for calendar objects for this type of date

(if you went for text as your variable values, be sure to put it in single quotes here)

Then clicking the buttons will alternate between showing calendar objects for either dates.

Re: Dynamic Filters

Sun, 19 Oct 2014 01:42:33 GMT

Thank you, Jakub!

Re: Dynamic Filters

Sun, 19 Oct 2014 01:43:11 GMT

Thank you, Marco!

Re: Dynamic Filters

MarcoWedel — Sun, 19 Oct 2014 07:33:07 GMT

you're welcome

regards

Marco