topic Re: How to make the default clear all button clear variables; without using macros in QlikView

How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 19:30:48 GMT

Hi, I'm slogging around mostly not answered or half-related posts looking for a way to make the Clear All button itself clear variable input boxes and not just the list boxes. Because Qlikview Management Console on the Qlikview server doesn't let us schedule automated reloads on qlikviews containing Macros, I need an angle to add something to the list of default Document Event Triggers listed under Settings->Document Properties: Triggers..

The default document event triggers are the four items:

OnAnySelect

OnOpen

OnPostReduceData

OnReload

I want Document Event Trigger that says OnClearAll that then lets me Add Action->External->Set Variable and maybe write a bunch of these actions to have it set each variable to blank (or '' or Null()).

If I must, I'll go with a textbox button or maybe check with people whether OnOpen or some other document/sheet event like that would be good to clear the variables. Really hoping I can get the Clear All button we already have to Clear All though. Making a clear variables button feels eerily like making a virtual backspace key...

Re: How to make the default clear all button clear variables; without using macros

vgutkovsky — Thu, 23 Oct 2014 19:56:28 GMT

Hi, Steve. That's not possible--the Clear button that is part of QlikView clears field selections, and not variables. I typically create (as you suggested) a text object that clears selections and sets variables back to default values. The OnAnySelect trigger doesn't fire when you press the built-in QlikView clear button, so you couldn't use that. I usually train my users to use the text object button and not the built-in button. In some cases, I even hide the AJAX or IE Plugin toolbar entirely.

Vlad

Re: How to make the default clear all button clear variables; without using macros

Anonymous — Thu, 23 Oct 2014 19:58:14 GMT

Hi,

I don't think there is anyway to do that with variables without using macro. You could clear each variable with a separate action or try instead of using variables creating your variable values in script as separate dataislands. Selections on these fields would then also be cleared with the clear all action.

Best regards

Stefan

Re: How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 20:11:20 GMT

The data islands idea to stuff the variables into fields is clever and I will keep that in my brain. However, the variables in this case can be pretty much any number anyone feels like entering (they relate to goals, be it the number of steps or minutes logged, or the number of times logged, weight loss, actual weight, etc. )

Thanks for the input though, that is a clever trick I'll add to my arsenal.

Re: How to make the default clear all button clear variables; without using macros

rustyfishbones — Thu, 23 Oct 2014 20:14:12 GMT

Hi Steve,

I have files automatically reloading in the Management Console and I have lots of Macros and it works fine

Regards

Alan

Re: How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 20:15:41 GMT

Thanks, hide the toolbar and make my own toolbar is probably the approach I'll be saddled with. Sorry there's no way to do what is desirable, but helpful answer points all around. (Not as hopeless as getting a functional logout button at least. )

Re: How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 20:26:13 GMT

Thanks, I'll re-visit that. We had an issue where we were trying to make our qlikviews export reports to excel when they refreshed themselves, and we couldn't use the 'store into' bit in script for that, so we tried macros. Subsequently, the qlikviews refused to refresh themselves, and people said it was because of the macros. They ended up pointing us to nPrint or windows task scheduler, but they were either unwieldy or qlikview server fought them someway.

It was awhile ago, but maybe the qlikviews were refreshing and just not the macros being run on the scheduler. If that's the case, then we might be okay with the macro route since people pushing a clear all button isn't anything we need to run through the qvmc scheduler.

I'll try it out and hand off a correct answer if it works, since I'm out of helpful answers now.

Re: How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 20:38:50 GMT

Can one of you all let me know how I might modify the macro in this post to work with input boxes that don't have predefined values?

Reset input box using macro on Clear All button

Correct answer there is for predefined value input boxes, and it was posted in 2012, so not sure anyone there will reply to my followup.

Re: Re: How to make the default clear all button clear variables; without using macros

vgutkovsky — Thu, 23 Oct 2014 20:58:52 GMT

Btw, I'm not so sure a Logout button is an impossible as you think. Take a look at the attached--just put it together. This will let you log out, as long as you have Login authentication enabled in the QMC. Copy the htm file to C:\Program Files\QlikView\Web and put the QVW anywhere in your User Documents directory structure. I think that's going to be my next blog post 🙂

Vlad

Re: Re: How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 21:08:22 GMT

Ah, that's funny. I will put this logout button to the test too. I had a theory it'd need to be some action to kick people to somewhere that makes them have to re-authenticate to get back in; 'a custom web page of some sort' I said, and it looks like you setup something like that. (I had the same idea, just lacking the skill set you seem to have. )

We need a logout button that works with Authenticate-Always, and makes it so when people push the button they can't get back in by any means unless they re-enter their login and password. Qlikview has a logout button that appears when you set authentication one step below 'always', but people can just wander back into the qvw without having to log back in. People sharing terminals or using multiple credentials need the logout button to actually logout without them needing to close out their whole browser.

Re: Re: How to make the default clear all button clear variables; without using macros

vgutkovsky — Thu, 23 Oct 2014 21:12:41 GMT

Ah, well I'm pretty sure that's not possible. You can't tell Windows (and Internet Explorer) to sometimes pass a user's logged-on credentials but not always.

Vlad

Re: Re: How to make the default clear all button clear variables; without using macros

stevelord — Thu, 23 Oct 2014 22:16:47 GMT

I'd just need the logout button to cause a situation where, once pressed, whoever is on that computer needs to log back in before they can access the qlikviews. (Versus just hitting the back button, or just navigating back to the qlikview without being challenged by a login screen.) I had a theory that the a real logout button might force a timeout, or fool qlikview into thinking you'd closed all your windows when you hadn't really (maybe delete whatever tracking cookie would make that happen). Run off topic, but fun conversation.

Re: How to make the default clear all button clear variables; without using macros

vgutkovsky — Thu, 23 Oct 2014 22:37:38 GMT

The best conversations come from tangents 🙂 I think maybe there's a fundamental misunderstanding. If you have the default QlikView authentication enabled, the reason you don't have to log on manually is because some browsers (IE, for example) will automatically pass logged-on Windows credentials to any site on your company's intranet that requests it, such as the QV AccessPoint. Even if you were to somehow force a "log off" it wouldn't work because the browser would immediately re-pass the same credentials. What you're looking for is a blended authentication system that would first use automatic authentication from a browser and then, after some sort of "log off" event is triggered, would switch to a manual login system. I've never heard of anything like that. It might be possible to create something like that with some guru-level .NET programming, but it really has nothing to do with QlikView.

Vlad

Re: How to make the default clear all button clear variables; without using macros

stevelord — Fri, 24 Oct 2014 13:48:51 GMT

If someone in our company is logged in as domain\teamname, and I go onto accesspoint and want to log myself in as domain\steamname from my machine, I have to enter the login and password.

Granted, this would kick the other person off if it was a document cal and we try to access the same document with that, and maybe they could reconnect and kick me off without re-authenticating, but Qlikview itself is doing a fine job observing logins either by raw count or by machine. Either way, my browser isn't tracking the fact the other person is logged in and clearing me through, it's just holding on to the fact I'm logged in. It doesn't hold onto the fact I'm logged in if I push 'log out' on say, a Bank's website (or Amazon's either I think, if I push sign out), and I always have to re-authenticate there. This happens from either the company intranet, or my home wifi. People just wanting qlikview to do that.

Re: How to make the default clear all button clear variables; without using macros

stevelord — Fri, 24 Oct 2014 13:52:50 GMT

Anyway, even with the intranet or same computer, having a logout that forces a timeout of the sort that requires re-authentication to get back in might do the trick. People who made Qlikview are the Gurus as evidenced by the existence of Qlikview, and should be able to figure something out on this front.

Re: How to make the default clear all button clear variables; without using macros

stigchel — Fri, 24 Oct 2014 14:55:02 GMT

I think I have made some kind of working example of this (see attached), all be it that you need to add each clear variable action

What I do is:

-load a seperate field Clear with value Clear

-This field has a trigger to clear a variable and set the value of Clear to Clear again

The Clear all from the toolbar triggers the trigger on Clear, which in turn clears the variable

Re: How to make the default clear all button clear variables; without using macros

stevelord — Fri, 24 Oct 2014 15:04:09 GMT

Granted, that's a variation of the text-box button approach, but it's _a_ clear button that does what I want, so happy to give away the last of the credit and close this thing out now. (I think I gave helpful credit to a level 10 person for suggesting I hide the main toolbar and make my own that does what I want it too- similar to your clear field/button approach idea but without the qvw attached. ) Another person says a builtinmacro of this sort may not interfere with qvmc scheduled reloads, so I may try that too. Higher priority stuff crowding my day today, so will leave this string alone now. We accumulated a few nice approaches for others to try in one string now.

Re: How to make the default clear all button clear variables; without using macros

vgutkovsky — Thu, 30 Oct 2014 20:21:23 GMT

Steve, in case you're interested, a more sophisticated version of the logout file is now available here: http://www.infinityinsight.com/blog/?p=275

Vlad

Re: How to make the default clear all button clear variables; without using macros

anothergreg — Mon, 29 Aug 2016 20:31:00 GMT

stigchel‌ I tried incorporating the elements here into my own workspace, but for some reason it's not working on mine where your provided example works flawlessly. I've modified the script to include the Clear table, I changed the Field Event Trigger for Clear to be an OnSelect action. The action does a Set Variable and Select in Field exactly as is in your example. When I hit clear, though, my Clear Listbox deselects the value. Is there another step I need to take to make this work properly? I've modified my workspace even down to the exact spelling as in your example in an effort to get it to work, but to no avail.

Re: How to make the default clear all button clear variables; without using macros

stigchel — Tue, 30 Aug 2016 09:59:56 GMT

I don't know, I tried recreating this in a new document and it worked again. Can you share your qvw?