topic Re: Actions and variables, what's happening ? in QlikView

Actions and variables, what's happening ?

fredericvillemi — Mon, 13 Mar 2017 11:57:20 GMT

Hello,

I'm using Qlikview 11.2 SR12. It's not the greatest version and maybe I will have to upgrade because I think I have a bug about actions and variables.

I want a button to remove all filters except 1 if it is already selected.

So my idea is to make a button with

set a variable to the value of getfieldselections
clear all
select the field with the value of my variable

The problem is that it seems Qlikview only update the variable value when all the actions have been completed.

In my selection of Company,

If I select the Company1, it will end with everything cleared and Company1 in the variable.

But after that, if I select Company2 and press the button, it will clear all, select Company1 (because it was in the variable) and then put Company2 in the variable, even if the Set Variable was the first action.

Look at the example provided.

Is there an error in my code ? is there a walkaround or do you know if another SP of 11.2 fixes that ?

Thanks

Re: Actions and variables, what's happening ?

marcus_sommer — Mon, 13 Mar 2017 12:14:47 GMT

The actions in qlikview won't be executed seriell. This meant you couldn't get a stable solution with a chain of actions if they are depending on eachother in any way. Perhaps you need another usability with multiple buttons and/or back/forward-buttons or bookmark-actions or something similar. Maybe also this is helpful for you: Tracking the historical selections.

- Marcus

Re: Actions and variables, what's happening ?

lironbaram — Mon, 13 Mar 2017 12:19:00 GMT

some of the actions in Qlikview take time to update and there for when applying several actions

you'll need to include a macro that do a sleep function

but the good news you don't need this sequence , just use the action clear other fields

that clears all the fields except to the field you set

Re: Actions and variables, what's happening ?

fredericvillemi — Mon, 13 Mar 2017 16:00:55 GMT

I still take that as a bug : a succession of Clear and Select always work fine. But setting a variable seem to happen only when the action list is over. Too bad.

Clear other fields is nice but if you have selected nothing, it will select All .. I don't like that .. I want to clear other, not clear other and select all !! Again I would say it's a bug.

Re: Actions and variables, what's happening ?

fredericvillemi — Mon, 13 Mar 2017 16:06:45 GMT

Thanks for your very interesting link.

I still think my problem could be easily fixed (and is some kind of a bug) : all actions of selecting and clearing are sequential. Too bad the Set Variable is not and only occurs when the actions are over.

I have fixed my issue with the tip of another article : locking the Company field, clearing everything and unlocking the Company. It adds a lock/unlock to the history of filters but it's the better way to do I think

Re: Actions and variables, what's happening ?

brian554xx — Thu, 11 May 2017 20:29:58 GMT

If the objective is to clear everything except a particular field (which I call "preservefield"):

Unlock all
Lock preservefield
Clear all
Unlock preservefield

If you must also preserve the already-locked fields, add this in the script:

Set HiddenPrefix = '_'; // or whatever you like

Preservation_Island:
NoConcatenate
LOAD Distinct
preservefield,
preservefield as _shadowfield
Resident Table_With_Preservefield;

In the button actions:

Select possible _shadowfield
Lock _shadowfield
Clear all
Select possible preservefield
Unlock _shadowfield
Clear _shadowfield

Let me know if that works for you!

Re: Actions and variables, what's happening ?

fredericvillemi — Fri, 12 May 2017 08:42:18 GMT

Thanks, yes I have done this way (without the code to preserve the locked fields but it is ok for me)

I'm just unhappy about the fact Actions and triggers are not really sequential in Qlikview but I'll do with it

Thanks

Re: Actions and variables, what's happening ?

Anonymous — Fri, 27 Oct 2017 18:58:04 GMT

Hi Frederic Villemin,

Do Actions work on Ajax browser when published.

I have a few Red Green Amber Text objects and have Actions on them to " select in fields Action " to filter out a table beneath it. Will these Select In field Actions of these text boxes work in Ajax browser. Basically will Actions work in Ajax browser. Please kindly let me know. This would be really helpful! Thanks in advance!

Re: Actions and variables, what's happening ?

Anonymous — Fri, 27 Oct 2017 18:58:43 GMT

Hi Marcus Sommer,

How are you? I have a question.

Do Actions work on Ajax browser when published.

Re: Actions and variables, what's happening ?

Anonymous — Fri, 27 Oct 2017 18:59:46 GMT

Hi Brian Schiefen, I have a Question on Actions :

Do Actions work on Ajax browser when published.

Re: Actions and variables, what's happening ?

brian554xx — Fri, 27 Oct 2017 21:20:29 GMT

I have not tested all actions. The ones I use seem to work.

Next time you move a version to production, create a private sheet (show condition OSUser()='<yourusername>' * note below). In production, add a button in that sheet to test actions.

I was planning to tell you that any properties available in the Properties box in web view would work in production. However, I do not believe this is true. For example, you can create a grid-style multi-box in web view, but it looks no different from a regular multi-box - until you turn off web view.

* There may be more to your full username than what you expect. When in doubt, temporarily create a text box, or temporarily borrow a caption, with the formula =OSUser(). I got tired of that and I wanted an easier way to add more people to the condition, so I started using WildMatch5(OSUser(), '*schiebx*', '*otherperson*', '*example*') for the show condition.

Re: Actions and variables, what's happening ?

Anonymous — Sat, 28 Oct 2017 07:17:09 GMT

Hi Brian,

Will this action work in Ajax browser.

I plan to use simple " Select In Field " Actions present in a Text object as shown in the attached picture to " select In Field " values from a Field to drill down tables. Will this action work in Ajax browser.

Please reply to this as soon as you see this post. That will be really helpful. Thank you.

Re: Actions and variables, what's happening ?

fredericvillemi — Mon, 30 Oct 2017 08:34:14 GMT

Hello,

yes Select in Field works correctly in Server / Ajax Mode

What doesn't really work is to make multiple triggers with links to each other like Setting a variable, using it in select field, etc. Qlikview won't update variables in the order we would like it to do

But yes Select in Field works correctly (as most actions)