topic Event Triggers OnChange Not working? in QlikView

Event Triggers OnChange Not working?

Tue, 14 Jan 2014 16:12:35 GMT

Hi All,

I have a document, in it there is a table that contains Dates in various forms (IE: Date, Calander Month, Calander Year,Calander Week, Financial Year, Financial Month... etc)

There are OnChange Event triggers on these fields to capture selections and change the value of 2 variables.

Like so:

v_filter_DateRangeStart= Min(<DateSelected>)

v_filter_DateRangeEnd= Max(<DateSelected>)

When these variables are changed, there is a trigger which sets the filter of the document to be "='>=' & Date(v_filter_DateRangeStart) & '<=' & Date(v_filter_DateRangeEnd)"

In the filters section of the document we have tableboxes for the fields in the date table, the idea, and how it works in the first document, is that when a selection is made in the year box (for example) this then triggers a change in the variables (v_filter_DateRangeStart, v_filter_DateRangeEnd) which in turn changes the filter on the target date field as above. There are also some input boxes which allow direct input into the variables (v_filter_DateRangeStart, v_filter_DateRangeEnd).

When typing a date into the input box, the document filters as expected. However the variables to not change when trying to use the table boxes, as it does in the other document.

I have looked everywhere i can to make sure that the document properties etc match, but there seems to be something i have missed/have forgotten.

Since creating the original document we have upgraded from QV 10 to 11.2, was somethign stopped here to forbid chaining triggers? or is there a setting somewhere which may have been turned off that i need to reactivate?

any help would be greatly recieved.

Thank you,

Chris

Re: Event Triggers OnChange Not working?

Nicole-Smith — Tue, 14 Jan 2014 16:16:37 GMT

You can't trust QV that the triggers are happening in the order you have set them in. Maybe try changing the trigger to the following so that it isn't dependent on previous triggers:

='>=' & Date(Min(<DateSelected>)) & '<=' & Date(Max(<DateSelected>))

If this works, you know things just aren't happening in the order you expect them to in the back end.

Re: Event Triggers OnChange Not working?

phaneendra_kunc — Tue, 14 Jan 2014 16:17:37 GMT

i have seen the same issue too...Try this trick....

Place two text boxes with your variables as expressions..

=v_filter_DateRangeStart

=v_filter_DateRangeEnd

And hide them by shrinking the size..or placing some where behind...

Do not hide using a invalid condition in "layout --> Show"

Re: Event Triggers OnChange Not working?

Tue, 14 Jan 2014 16:23:38 GMT

I don't see how the order could be getting confused... but then i have given up trying to understand qlikview! i will give this ago. Simplifying the chained triggers is probably not a bad idea anyway, as this was originally developed to allow for the user to change the date the user wishes to filter on.

Re: Event Triggers OnChange Not working?

Tue, 14 Jan 2014 16:24:27 GMT

I will also try that trick, which again makes no sense to my simple brain, as keeping the functionality would be nice.

i will play following the advice, and get back to you, marking helpful and correct etc

Thanks! both

Re: Event Triggers OnChange Not working?

phaneendra_kunc — Tue, 14 Jan 2014 16:28:53 GMT

I know...some times i feel the same too...

Also make sure your text boxes should show the value not Min(Dateselecte) or Max(Dateselected) text...

if it shows text place equal and dollar sign..

=$(v_filter_DateRangeStart)

Re: Event Triggers OnChange Not working?

Wed, 15 Jan 2014 15:18:28 GMT

I have tried this and played around trying to get it to work, but it just doesnt look like the trigger is firing at all.

As you recommended, i simplified the trigger.

There is only one event on the field "Calander Year" for OnChange and that is exactly what is written (and working) ont he OnChange event of the variable, Yet nothing. I added to the "OnSelect" event, and nothing happens either.

So still no luck 😕

Re: Event Triggers OnChange Not working?

Wed, 15 Jan 2014 15:18:57 GMT

I am not sure if there is something i am not doing, or steps that may have been missed, but this doesnt seem to have made a difference

Re: Event Triggers OnChange Not working?

Nicole-Smith — Wed, 15 Jan 2014 15:26:36 GMT

Can you post a .qvw?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Re: Event Triggers OnChange Not working?

Wed, 15 Jan 2014 15:38:57 GMT

Hopefully this will be enough to give you an idea. due to strict IG rules (as we are a hospital!) i have limited the load to 10 records per table, and scrambled anythign that could identify a patient.

Here is the scambled and limited file. You may have to navigate to the date filter section (apologies, but if igured you wold want to see this as close to "natural") Click "Theatres Dashboard" and then "Show Filters" and you will be on the filters screen.

Below the left hand menu is a text object displaying the current date range selected, that is a good sign to see what the filters are doing.

If the date boxes dont show (the ones with the silver header bar) then you may need to reset "v_filter_Tab" to 1.

Re: Re: Re: Event Triggers OnChange Not working?

Nicole-Smith — Wed, 15 Jan 2014 16:44:52 GMT

You have constraints on the variables. The field [Lookup Date] is formatted as a number and not a date. You need to wrap the triggers in date() in order to get them to work:

I've also attached a working example for the [Week (Calendar)] field.

Re: Re: Event Triggers OnChange Not working?

Wed, 15 Jan 2014 16:49:54 GMT

yup, i knew it would be me doing something stupid like that! Although i have just checked the original, which was exactly the same as the one i sent you, so how that one works i do not know :S

Thank you so much for the help!

Re: Event Triggers OnChange Not working?

Thu, 16 Jan 2014 13:33:31 GMT

Hi again,

sorry to report i was a bit too eager to mark this as complete. It would appear that part of the issue has been solved. when making selections in the table boxes, the variables are now changing. However, when the variables change via this method, it appears that the trigger to filter the document is not firing and the data is not being filtered. Howevr, when i change the values in the input box manually, the data does filter.

I have checked to make sure that the triggers on the variables are cast as the right data type.

Starting to feel like im going around in circles, but its so close!!

Any help would be appreciated - the document is attached.

Re: Re: Event Triggers OnChange Not working?

Nicole-Smith — Thu, 16 Jan 2014 13:57:53 GMT

Okay a couple things...

This goes back to what I first said about triggers not happening in the order you expect them to in QV. To fix this, I put the triggers to filter on the same fields setting the variables, not on the variables themselves. In what I am attaching, I have fixed this for the [Week (Calendar)] field. I have added the filter triggers to both the OnSelect and OnChange options. Also note that [Lookup Date] is formatted as a number and [Operation Date] is formatted as a date, so we need to treat them differently.

Re: Event Triggers OnChange Not working?

Thu, 16 Jan 2014 14:10:37 GMT

I am so sorry for this, i could have sworn that was a date.

I am looking at the document you had attached, it appears that week (Calander) is not filtering the document, which is the issue i had before.

Also, can you explain why you have added and if statement? i cant quite understand what it's doing.

Re: Event Triggers OnChange Not working?

Nicole-Smith — Thu, 16 Jan 2014 14:15:19 GMT

It does filter it if you select something valid like Week 48 (the other weeks aren't in Operation Date):

The if statement is for when you clear out the selection in the [Week (Calendar)] field. Without it, it won't clear the selections in [Lookup Date] or [Operation Date].

Re: Event Triggers OnChange Not working?

Thu, 16 Jan 2014 14:18:28 GMT

Thank you for explaining this, and sorry for being so dense about it all.

You have been a great help!

Re: Event Triggers OnChange Not working?

Nicole-Smith — Thu, 16 Jan 2014 14:19:59 GMT

You're welcome

It was definitely a challenging problem to solve.