topic Re: How to trigger clear all fields from one table in QlikView

How to trigger clear all fields from one table

roland74 — Tue, 03 May 2016 13:48:10 GMT

Hi all,

I have created some calendar buttons in QlikView for Today, Yesterday, Current Week/Month and Previous Week/Month.

These buttons contain a lot of actions, first I use 'Clear Field' for all calendar fields and after that I use 'Select in Field' actions to set the correct date, day, month, week and so on.

I wonder if it is possible to use the Clear Field action for all fields in my Calendar table!?

In a textbox I can use ='['&Concat({1<$Table={'Calendar'}>}distinct $Field,'],[')&']' to show all fieldsfrom the table.

Does anyone have a bright idea?

I cannot use Clear All because I do not want to lose selections on fields other than the calendar.

Thanks a lot!

Re: How to trigger clear all fields from one table

sunny_talwar — Tue, 03 May 2016 14:35:20 GMT

I don't seem to think it is possible using Clear Field action as that seems to be taking only one field at a time. Maybe you can use SubField(Concat({1<$Table={'Calendar'}>}distinct $Field,'|'), '|', 1), SubField(Concat({1<$Table={'Calendar'}>}distinct $Field,'|'), '|', 2) and so on... if you don't want to type each of the field name.

Re: How to trigger clear all fields from one table

marcus_sommer — Tue, 03 May 2016 14:56:59 GMT

Like Sunny said you could apply only one clear (or select) action at one time (unless you would use macros which could run this within a loop). But the question for me is - why do you are not using bookmarks?

- Marcus

Re: How to trigger clear all fields from one table

sunny_talwar — Tue, 03 May 2016 15:01:42 GMT

Marcus‌ is it possible to just put a bookmark on some fields? If not, the bookmark will take the selections at the time of bookmarking as default and as soon as we apply the bookmark those fields will also change, right? Is there a work around?

Re: How to trigger clear all fields from one table

marcus_sommer — Tue, 03 May 2016 15:10:52 GMT

Hi stalwar1‌you could add the bookmark-selections on top of existing selections and the selections within the bookmark could be search-expression like: null() for each of the calendar-fields which would clear them. I have never tried these logic within a bookmark only within actions but I think it's a try worth.

- Marcus

Re: How to trigger clear all fields from one table

sunny_talwar — Tue, 03 May 2016 15:12:20 GMT

I agree. For me it is good opportunity to learn something new. I will see if I can replicate what you just mentioned

Re: How to trigger clear all fields from one table

sunny_talwar — Tue, 03 May 2016 16:57:16 GMT

I gave it a shot, but not sure how it would work. Attaching the sample I worked with

Re: How to trigger clear all fields from one table

marcus_sommer — Wed, 04 May 2016 13:50:40 GMT

Hi Sunny,

many thanks for the sample-file. You are right it's not so easy then I thought it would be. If you simply applied =null() on a field the selection will be cleared without applying the search-expression as selection and therefore there is nothing what you could add to a bookmark.

Therefore I applied a search-expression like: if(1=1, 1) for the fields (I have done this for Date and Month) and created a bookmark with them. Then I exported the bookmark to the desktop, opened it with a editor, searched for the "if(" and changed it to =null() and saved the file. Aterwards I imported the bookmark - and yep - it worked.

The same result should be possible with creating and/or changing a bookmark with the macro API but it will be probably not so understandable like my first approach.

- Marcus

Re: How to trigger clear all fields from one table

roland74 — Mon, 09 May 2016 12:20:48 GMT

Thank you both for your input!!

I am not really familiair with bookmarks. Is it possible to have a dynamic bookmark to filter yesterday/today, last/current week, last/current month, etc?

The user wants to keep the selections other than fields from the calendar when using the buttons!

Thanks!

Roland

Re: How to trigger clear all fields from one table

marcus_sommer — Tue, 10 May 2016 08:22:45 GMT

Yes you could have dynamic bookmarks which are using search-expressions. Try for example something like this:

=Date=today()-1 // in Date-field for yesterday

=month(today()) // in Month-field for current month

- Marcus