topic Re: Clear Selections in QlikView

Clear Selections

Anonymous — Mon, 29 Feb 2016 21:07:07 GMT

Hi All

I am trying to set a trigger to clear selections

So i have 4 tabs but on each tab there is a different calendar....Long story short i couldn't make a a Master calender because i had linked my Data model a specific way and if i added this calender it caused a loop so i kept individual calenders.

Now when i select a tab i want all selections to clear, so User makes selections....goes to the next tab and as soon as the next tab is selected all clears again....Any ideas?

Thanks in Advance!

Re: Clear Selections

swuehl — Mon, 29 Feb 2016 21:12:15 GMT

Maybe use an OnActivateSheet trigger with an appropriate action?

Or use alternate states?

Re: Clear Selections

Anonymous — Mon, 29 Feb 2016 21:13:37 GMT

...>Alternate States.....Good Idea, didnt think of that

Thanks

Re: Clear Selections

Mon, 29 Feb 2016 22:23:03 GMT

Hi Adil.Hussain‌

The OnActivate Sheet is also a good idea, and for your calendar loops.. have you tried Date link table ?

I think giving one master calendar with an option to pick the type of date is much handy for the end user.

We have 6 different date types in our business ( Shipped date, Delivered date, Created Date, etc.) a User have to select a type of date from the list box before picking a date rage.. this gives them flexibility to change the dimension based on type of date.

Re: Clear Selections

Anonymous — Tue, 01 Mar 2016 11:11:20 GMT

Ho w would i do this?

Thanks

Re: Clear Selections

Tue, 01 Mar 2016 23:41:11 GMT

Adil.Hussain‌ Happy to show you how if you can send me a sample QVW with type of dates and data model you have.. will be easy for me to provide you best suitable calendar script and table model based on what you already have. Regards,

Re: Clear Selections

rwunderlich — Wed, 02 Mar 2016 04:54:55 GMT

‌Here is an example of using a datalink table and a common date dimension.

http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

Re: Clear Selections

Anonymous — Wed, 02 Mar 2016 05:20:53 GMT

select the button and give the clear section and go to the action button give the add action clear all