topic Re: Clear Filters in QlikView

Clear Filters

Sun, 19 Jul 2015 10:55:31 GMT

Hi Team,

Kindly help me generate the following result.

I have the following 3 filter selections -

1) FromDate (Calendar object)

2) ToDate (Calendar object)

3) Month (Multibox object)

Issue : To remove the date/month filters.If one selects the month, then the dates should go away and vice versa (i.e. Fromdate and Todate)

My understanding : Create a button for Clear Selection and mention all the above three fields using Clear Field action. But then the problem here would be that the user every time have to click on the Clear button object before any selection.

Thanks in advance.

Re: Clear Filters

Anonymous — Sun, 19 Jul 2015 11:06:12 GMT

Try using a Document Trigger ::

Document Properties
Triggers
Field Event Trigger
Highlight your Month field
OnSelect <Add Actions>
Create Actions to clear the fields you wish to clear

Re: Clear Filters

Kushal_Chawda — Sun, 19 Jul 2015 11:09:12 GMT

Are you using Variable or field for calender object?

Re: Clear Filters

qlikviewwizard — Sun, 19 Jul 2015 14:36:58 GMT

Hi ruchika123

Could attach the sample application. It would help the folks to give best answer quickly. Thank you.

Re: Clear Filters

Mon, 20 Jul 2015 03:23:37 GMT

Hi Team,

Thanks.

@Bill : Your input works for me. Thanks

Regards

Ruchi