Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Filters

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?

7 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

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).

Not applicable
Author

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.

MarcoWedel

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

kuba_michalik
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author

Thank you, Jakub!

Not applicable
Author

Thank you, Marco!

MarcoWedel

you're welcome

regards

Marco