topic Re: Save Selections and Clear Button in QlikView

Save Selections and Clear Button

dmohanty — Wed, 20 Nov 2013 09:10:28 GMT

Hi All,

I have a requirement like below. Please help me in providing steps/scripts to do so. It would be helpful if someone shows with a Sample QVW File.

In my dashboard I have a simple List Box. The user should should select something from List Box and close the document. Next time, when the dashboard is opened from Access Point, the same selections should be visible in List Box.
After the selections are visible, User should select some more values in the List Box and a CLEAR BUTTON should be there to clear the new selections. This button should clear the new selections and go back to those selections which was found after opening the document.

N.B: All operations are performed on the docuemnt on Access Point (Plugin/AJAX)

Please suggest to achieve this.

Regards!!

Re: Save Selections and Clear Button

jonasheisterkam — Wed, 20 Nov 2013 09:23:15 GMT

You can use Set Clear State. Right click on the top ajax menu. I think you can set it also with macro, what the user see next time depends on server settings, if he can create bookmarks you can do it with a macro too and load it on open.

Re: Save Selections and Clear Button

dmohanty — Wed, 20 Nov 2013 09:29:30 GMT

Hi Jonas,

Could you please throw some more light on this? I don't have experience on Macro as well, so no idea how to create this.

Where is Set Clear State exactly?

Re: Save Selections and Clear Button

jonasheisterkam — Wed, 20 Nov 2013 09:35:05 GMT

You can find the API Guide QVW here

QlikView Core COM API Guide - Version 11

There the most commands with a example. A macro can be written in the modul part ander extra and call with a action. Actions can add to Button, TxtBoxes or on Document/Sheet/Field/Var changes. In the API QVW you find the macro part on the Automation Sheets.

Command to set the State as Clear State:

Makro:

sub test

ActiveDocument.SetClearState

end sub

Action:

call Makro

test

Re: Save Selections and Clear Button

Wed, 20 Nov 2013 10:08:19 GMT

hi,

I am not sure that it will work with (Plugin/AJAX).

Check this attach file and let me know.

Regards,

Ashutosh

Re: Save Selections and Clear Button

Wed, 20 Nov 2013 10:16:44 GMT

Hi,

Just in the Clear buttoon add 2 actions.

- The first one "Clear All" action

- The second one "Apply Bookmark" with your previously saved and desired selections

Regards,

Jaime

Re: Save Selections and Clear Button

dmohanty — Wed, 20 Nov 2013 17:52:23 GMT

Hi Jonas,

Thanks a ton to you. Your attached API Guide a helped a lot and I was able to achieve my requirements by writing Macros.

Also, I created a Macro, so as when a Button will be clicked, a Pop Up should come up. Its working perfectly in IEPlugin, but not in AJAX mode. Could you please suggest on how it would be visible when opened in AJAX mode?

Regards!

Re: Save Selections and Clear Button

dmohanty — Wed, 20 Nov 2013 17:53:19 GMT

Thanks Jaime ,

Your tips were helpful a lot too along with Jonas's reply.

Re: Save Selections and Clear Button

dmohanty — Wed, 20 Nov 2013 17:54:34 GMT

Hi,

Somehow values were hardcoded in variable, but good approach. Though did not get a chance to work in server.

Re: Save Selections and Clear Button

jonasheisterkam — Wed, 20 Nov 2013 18:07:24 GMT

Easy way: Use the Action set value to var. Its under External i think, i use the german version so i can't tell you the exact menu names. In the TxtBox you can use in the layout tab VAR = X then show. On the shown TxtBox you can set VAR to Y by a action. It will hide the TxtBox on click.

Re: Save Selections and Clear Button

dmohanty — Wed, 20 Nov 2013 18:15:10 GMT

That's a task I tried also, But it has lot of other stuffs to do also, Like Close the Message Box on clicking OK/ 'X', colors etc etc...that became a mess.

So I switched to Macro to put an easy code:

ActiveDocument.ShowPopup "Data Saved Successfully", 5000.

It appeared nice, with a 'X' symbol to close as well or it vanishes after 5 seconds as well. But this does not works in AJAX.

Re: Re: Save Selections and Clear Button

jonasheisterkam — Wed, 20 Nov 2013 18:27:35 GMT

You can add more then one action on the button. So you can start a macro and show TxtBox without any macro code. In the qvw i have add a example.

Re: Save Selections and Clear Button

Wed, 20 Nov 2013 19:08:05 GMT

The bookmark are the best one, each time user select u can save it and re-run it at any time. I'v used it and it work.

try to create a Bookmark Button

Re: Save Selections and Clear Button

dmohanty — Thu, 21 Nov 2013 07:21:01 GMT

Thanks again Jonas,

That was quick and effective!