topic Re: Help required to write a macro on Listbox in QlikView

Help required to write a macro on Listbox

rajtechnocraft — Mon, 19 Sep 2011 05:29:01 GMT

Hi Members,

Just wanted help to consolidate 5 applications into main application

I have 1 main application and 5 seperate applications.

In main application i have created a list box which contains the name of these 5 applications.

Listbox

App1

App2

App3

App4

App5

What i want is when a user selects any one of these applications from a list box he should be able to navigate to the desired application.

Iwant a script(Macro) on listbox selection to call an application.

I did this thru button and wrote macros .It works fine but the buttons are consuming space in my application.

So i used list box object but not sure how to write a macro on listbox to call these applications on selection.

Would be thankful to you experts if you can help me with this.

Raj.

Help required to write a macro on Listbox

jykang0638 — Mon, 19 Sep 2011 06:00:03 GMT

Hi Raj,

You can use OnSelect event or OnChange event of the list box field at the Field Event Tiggers - similar to where you were doing through a button.

You can find Field Event Trigers in Document Properties - Triggers tab.

Good luck!

Help required to write a macro on Listbox

rajtechnocraft — Mon, 19 Sep 2011 06:12:02 GMT

Hi ,

Thanks for responding but how do i add all 5 applications in the add actions button.

I am stuck over here.

In buttons i could add mavcros seperately as i had individula button for each application..

Here i don't as i have a single list box which contains all 5 applications as data element.

And when the user selects any 1 application from list box he should be able to navigate to the desired application.

I know a variable has to be used which will link to List box and keep track of user selection but variable Listbox and user selection how to integrate i am not getting the macro.

Help required to write a macro on Listbox

jykang0638 — Mon, 19 Sep 2011 06:37:33 GMT

Hi,

I will assume your field name of list box as AppName.

In the OnSelect event of Document Properties' Field Event Triggers, select AppName and then click Add Actions(s) button of OnSelect.

In the Actions window, select Add - External (Action Type) - Launch (Action) sequently.

In the Application text box, put the expression like the below.

=If(Count(distinct AppName) = 1, 'Your Application Path' & AppNmae & '.qvw')

I hope this will be help you.

Re: Help required to write a macro on Listbox

rajtechnocraft — Mon, 19 Sep 2011 07:15:12 GMT

Hi Abhinav

Attached is the folder.

Listbox Folder

Re: Help required to write a macro on Listbox

jykang0638 — Mon, 19 Sep 2011 09:56:51 GMT

I am really sorry I couldn't carefully check and test the behavior of trigger.

Some of actions such as Export, Launch, Open URL, Open QlikView Document in the External are not available as document and sheet trigger.

Therefore, you have to use a object's(button or text object) event with the list box.

I will attach a sample app but now I can't attach a file because of company security policy.

Re: Help required to write a macro on Listbox

jykang0638 — Mon, 19 Sep 2011 12:40:48 GMT

I am going to attach two sample apps achiving your goal.

Check the description on the each app.

I hope these will be help you.

Thanks.

Re: Help required to write a macro on Listbox

Tue, 20 Sep 2011 04:25:27 GMT

Hi Raj,

Plz find the attached zip folder containing a solution for you.

I have used the same files given by jykang to illustrate.

The functionality of using a macro on listbox has been implemented.

Just use the "RadioButton_SelectionUsingUserClickAction.qvw" to see the solution.

Rgrds,

Abhinava

Re: Help required to write a macro on Listbox

rajtechnocraft — Wed, 21 Sep 2011 06:18:38 GMT

Thanks alot for your efforts and time and sending the application

Highly appreciated

Re: Help required to write a macro on Listbox

rajtechnocraft — Wed, 21 Sep 2011 06:20:47 GMT

Thanks alot for your efforts and time and sending the application Highly appreciated

Re: Help required to write a macro on Listbox

rajtechnocraft — Wed, 21 Sep 2011 06:21:52 GMT

Thanks alot for your efforts and time and sending the application Highly appreciated

Re: Help required to write a macro on Listbox

rajtechnocraft — Thu, 22 Sep 2011 06:41:50 GMT

Can u help me with one more enhancements in this what i have created in this is seperate applications with respective tabnaes.

i have created tabnames of respective applications in the listbox

So when a user clicks he should be able to navigate to respective application with their related tabs.

So listbox should have dual functionality select respective application with related tabs in tha application which i have included in Listbox

Re: Help required to write a macro on Listbox

Thu, 22 Sep 2011 07:01:04 GMT

Hi Raj,

Can you attach the application.. I don't understand what you mean by tabnames.

Rgrds,

Abhinava

Re: Help required to write a macro on Listbox

rajtechnocraft — Thu, 22 Sep 2011 07:12:38 GMT

Hi ,

I have attached the list box folder

Re: Help required to write a macro on Listbox

rajtechnocraft — Thu, 22 Sep 2011 07:32:14 GMT

Hi Abhinav, The attached List Box folder caontains the modified application which you will find in reponse to jykang0638 post as i was not able to find upload button in your response. Folder :Listbox zipped folder Application Name:TabMenuTesting.qvw Thanks for your time.

Re: Help required to write a macro on Listbox

Thu, 22 Sep 2011 07:37:43 GMT

Hi Raj,

You need to use the advanced editor in order to upload content.

Rgrds,

Abhinava

Re: Help required to write a macro on Listbox

rajtechnocraft — Thu, 22 Sep 2011 07:45:17 GMT

Hi Abhinav,

Thanks i have attached the zipped folder

Folder Name:ListBox example

File to be considered: TabNames_Testing.qvw