topic Re: Variables, Triggers and the Back button in QlikView

Variables, Triggers and the Back button

jcamps — Wed, 01 Feb 2012 15:18:06 GMT

Hi,

In my QVW, I'm using a trigger event to change the value of a variable when the selection changes. So, when I make a selection, the event triggers and the variable changes. So far, so good. My problem is with the back button: the first time I click on BACK the variable rolls back, and I need a second "Back" click to undo the original variable. This is not acceptable since the variable value is related to the selection, and a single "back" leaves an incorrect state.

A simple attached xample might help:

- field MYFIELD, values 1,2,3

- variable MYVAR

- Objects: MYFIELD Listbox, and MYVAR Textbox.

There is a ONSELECT trigger on Myfield, that sets MyVar as "=10*Myfield".

First, select "1" on MyField. the event triggers and sets the MyVar as 10*1... so the TextBox displays "10".

Repeat with "2", same logic and the TextBox displays "20".

So far, so good.

BUT, if I click "back", the VAR is rolled back to "10" BUT NOT the Field. This results in having on-screen the value "2" still selected, but the textbox displays "10"..... obviously, not 10 times the selected value

I dont know how to avoid the "variable change" being inserted in the "back pile". Any other workaround would be also apreciated.

Note that I know i could set MyVar directly as an expression so that it evaluates automatically, without a trigger. The problem is, this formula is very complex, and the same value is used over 50 times in a single sheet. For some reason QV does not cache the result, so it is evaluated 20 times in a single tab making the sheet unusable.

Variables, Triggers and the Back button

jcamps — Sat, 04 Feb 2012 21:36:03 GMT

No ideas? No way to change a variable's value without having it added to the "back queue"?

I thought I might try setting an inputfield instead, I have never done this and I don't know if it will have other issues (I need it running locally, and server-side both Plugin and AJAX...)

If anyone has any better ideas or have faced similar problems, please let me know, otherwise I'll let you know how the inputfield idea works...

Re: Variables, Triggers and the Back button

jeremy_fourman — Thu, 16 Aug 2012 18:56:31 GMT

Hi, this issue is affecting me as well the following link has it cofirmed as a bug. I am trying to track down if this has been fixed.

http://community.qlik.com/thread/14259

Re: Variables, Triggers and the Back button

Anonymous — Wed, 13 Feb 2013 20:35:52 GMT

Has anyone found a work around for this issue? I need to be able to skip the variable changes in the back button.

Thanks,

Re: Variables, Triggers and the Back button

Mon, 27 Jan 2014 19:07:24 GMT

Too bad there seems to be no fix for this. I was using this handy trick for date ranges. I love how it will enter in the max and min dates based up your selections so I moved the functions from the particular date fields to the OnAnySelect document event trigger (External --> Set Variable) to manipulate vStartDate and vEndDate. No matter what they select they will see the min and max date for their selection.

Imagine my dismay that the Back button now takes a two-clicks. This is going to be a tough call as to which functionality my users will be happier with.

Re: Variables, Triggers and the Back button

Thu, 27 Feb 2014 19:06:48 GMT

Did you solve this? I am using a field trigger to set 1 field = another. The BACK button changes the second field but not the first. I can't get a custom back button to work right either.

Re: Variables, Triggers and the Back button

Tue, 05 Aug 2014 08:05:12 GMT

Hi,

Does anyone know what going on with that bug?

Re: Variables, Triggers and the Back button

omerfaruk — Thu, 07 Jan 2016 10:38:52 GMT

Has anyone checked whether this has been resolved in the (available) QV12 version ?

Re: Variables, Triggers and the Back button

jcamps — Thu, 07 Jan 2016 14:54:07 GMT

I haven't checked, but I bet it hasn't, see resolution for this:

		Resolution
This was reviewed by R&D with ID 41442 and is closed as working as designed. The reason for this is that the current behavior (QV10 and QV11) is that the Back operation goes back one step from previously applied action. This includes all actions even variables.

Re: Variables, Triggers and the Back button

omerfaruk — Thu, 07 Jan 2016 16:13:45 GMT

to R&D who close the ticket for that reason,

Nothing wrong with the idea of allowing users go back one step backward from previously applied action (Though never needed this and really wonder if anyone needed..). However, allowing users to go back one step from previously applied "selection" is definitely the thing end users are more interested in. Because end users are not interested in the variables changing at the back end but interested in the selections they made on the document.

Re: Variables, Triggers and the Back button

hoodhill — Mon, 01 Feb 2016 11:04:56 GMT

Hi.

I don't see why you're using a trigger in this instance, why not just set the MyVar variable to '= MyField * 10'. You can then get rid of the trigger and once done the back button works (as it's backing out the last change).

Re: Variables, Triggers and the Back button

jcamps — Mon, 01 Feb 2016 13:24:29 GMT

This was just a simple example...

Real use scenario would be, I have a large set of selections in a tab. Some are on screen (most common, like "YearMonth" or "Brand"), others appear / popup on demand when user clicks on "More selections" (more rarely used, say "YearWeek"). What I do, create the "popup" objects with visibility based on a variable, say vPopupEnabled, plus a button that switches that variable back and forth between 1 and zero.

What the user does (just an example)

* Select in YearMonth

* ...

* Click on "Open selections"

* Select on YearWeek

* Click on "Close selections"

* Click on "Open selections"

* Change YearWeek

* Click on "Close selections"

* Switch to a different TAB where there are no popup selections

* Select on Brand

Now, if the user clicks on "Back", he'd expect to navigate back his selections. What he sees is as he clicks on "back":

OK, remove selection on Brand
Does nothing (!!)
Back on YearWeek
Nothing again (!?!)
Nothing again (@#@!!)
Mmmmm, WTF... let me switck back to the other tab. Oh well, what's the popup doing open now?

Hope that's clearer...

Re: Variables, Triggers and the Back button

jerrysvensson — Mon, 01 Feb 2016 14:50:03 GMT

We use the extension HideIt and remove the Back/Forward/Clear buttons. Problem solved in Ajax.

topic Re: Variables, Triggers and the Back button in QlikView

Variables, Triggers and the Back button

Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Resolution

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button

Re: Variables, Triggers and the Back button