Swop between dates

kamielrajaram — Thu, 15 Mar 2012 07:32:24 GMT

Good day,

I have 2 calendars in my document that references a different date field in 2 different tables. What I would like to do is swop between these calendars. My thinking is to have a to change the calendar selection which drives a variable to change the dimension used. Any thoughts on this.

Thank you

Regards

Kamiel

Swop between dates

jagan — Thu, 15 Mar 2012 07:47:28 GMT

Hi,

Provide two buttons for each date, if Button 1 is clicked then show the Date filters corresponding to this date and if another button is clicked then show the other date field filters.

In charts your expressions and Dimensions should also be dynamic based on the Button clicked.

Use variables to handle the date.

Your dimension should

If(vDateType = 'Date1', Date1, Date2)

likewise you have to handle this.

Hope this helps you.

Regards,

Jagan.

topic Swop between dates in QlikView

Swop between dates

Swop between dates