topic Trigger on clear? in QlikView

Trigger on clear?

Thu, 17 Sep 2009 21:31:38 GMT

Working in QlikView, I realizaed there is no trigger on clear button.. For example if you want to give variable, specific value, on clear, it isn't possbile.. The only way is to create button that will do clear through macro..

Am I right or wrong?

Tnx.

Trigger on clear?

disqr_rm — Thu, 17 Sep 2009 22:16:01 GMT

See enclosed.

Trigger on clear?

Fri, 18 Sep 2009 00:41:01 GMT


Rakesh wrote:
See enclosed. <div></div>

Hi Rakesh,

I have tried your solution (in QlikView 9) ...

Unfotunately it does not work and I do not understand your idea to solve this issue ...

Best regards

Stefan

Trigger on clear?

Fri, 18 Sep 2009 01:06:15 GMT

I wonder if this is an 8.5 solution. You can fix Rakesh's solution to work with version 9 by changing the OnChange trigger for field "a" to be an OnSelect trigger instead.

It seems that on a Clear, the OnChange isn't fired, but the onSelect is.

I think in order for this to work in a real application (more than one field to clear), then the trigger would need to be placed on the OnAnySelect event and every field would need to be checked to have 0 selections. I'm guessing you could use a loop to loop through all fields in the document and check for selections rather than hardcoding it for each.

Unfortunately, this is the best we have until we get some more trigger events.

Trigger on clear?

biester — Fri, 18 Sep 2009 01:06:48 GMT

I'd say: clear is a special form of Select ("Select NOTHING"), and there ARE triggers for OnSelect and OnAnySelect. But perhaps I'm misunderstanding something.

Rgds,
Joachim

Trigger on clear?

disqr_rm — Fri, 18 Sep 2009 02:15:19 GMT

Yes, unfortunately I only have 8.2 installed on the machine I have right now. I can make one example in v9 tonight when I get home.

The idea is to have a field (in this case field "a") with more than one records (in this case I loaded 2 records). Then a macro on "On Open" will select one record. Then a macro on "On Change" for this field will check if no records are selected, this will only happen if user presses clear button. Then the message pops-up and next line in the macro selects one record again. Same cycle....

Hope this makes sense.

Trigger on clear?

Fri, 18 Sep 2009 03:00:32 GMT

Oh, now I see. That's a pretty clever way to do it.

I just figured "a" was a dummy field and ignored that part. This is a great example of taking what the program gives you and adding functionality that wouldn't otherwise be available.

In order to make this work in version 9, add the IsClear macro to the OnSelect for "a" (it can be removed from the OnChange).

Trigger on clear?

Fri, 18 Sep 2009 04:34:31 GMT


biester wrote:
I'd say: clear is a special form of Select ("Select NOTHING"), and there ARE triggers for OnSelect and OnAnySelect. But perhaps I'm misunderstanding something.
Rgds,
Joachim<div></div>

Oh, I've not seen the trigger ... so nice idea and it works!! Thanks for your "additional" explanation ... 🙂

Best regards

Stefan

Trigger on clear?

disqr_rm — Fri, 18 Sep 2009 08:19:35 GMT

Glad to see that I have added some value here 🙂

Hi Vrbcic, Were you able to make it work for you?

Trigger on clear?

Fri, 18 Sep 2009 15:39:14 GMT

It is realy funny, when I posted this question to forum, I alredy tried to connect clear macro with OnChange trigger, and this solution didn't work for my case. But now I tried in a simple application and it is working..

So it is a problem with my application, and I don't know why.. Some bug is around 🙂

Trigger on clear?

derekjones — Fri, 10 Jun 2011 16:56:37 GMT

Hi all

I've tried using the above example and amended to NMiller's suggestion for QV9 and it doesn't appear to be working for QV10? The macro works fine standalone, just the trigger is not working OnSelect? Has something cahnged again in QV10?

Thanks

Derek

Trigger on clear?

derekjones — Fri, 10 Jun 2011 17:04:57 GMT

Sorry, just tried the change to OnSelect in Rakesh's example and it works fine in QV10. As Vrbcic, it appears to be something else in both our apps that seems to be stopping the trigger from firing? Back to headscratching!

Re: Trigger on clear?

derekjones — Sat, 11 Jun 2011 08:17:26 GMT

Okay, I've isolated the problem. It appears if you set a clear state (on another field not this dummy one obviously) then the trigger doesn't fire on the change of field a. Attached I've modified Rakesh's example qvw to replicate the error.

I can't see anyway around this apart from "simulating" my clear state in the macro i.e. don't set a clear state, but everytime IsClear macro is fired it does my selections in the macro.

Is this a bug? How do you report bugs to Qlikview so they have it on their radar to fix for next release?

Trigger on clear?

Fri, 16 Mar 2012 10:36:11 GMT

Did anyone make an improvement to this?

I would need to run a macro on clear but don't find any trigger that fires when I select clear.

Regards

Trigger on clear?

derekjones — Fri, 16 Mar 2012 14:06:02 GMT

No, sorry, I've not found any other way of doing this, I've had to not set a clear state in my app and manually simulate the clear state in my Macro in order to get around this.