topic Re: Passing value of variable in QlikView

Passing value of variable

Tue, 31 Mar 2015 08:27:22 GMT

I have a list box for countries.

I want to select one country and pass the name of country to database.

How can I do it ?

My Approach:

I am taking the currently selected Country into a variable vCountry = GetFieldSelections(Country)

This shows the value correctly in the text object as vCountry showing the value of currently selected country.

But when I want to pass it further, using $(vCountry), it still passes the value as 'GetFieldSelections(Country)' and not the actual selected country.

I tried using LET in script but still it didnt work, how can I set it to StringContent.

I dont want to use macro.

Kindly help, thanks in advance

Regards

Swapneel

Re: Passing value of variable

Ralf-Narfeldt — Tue, 31 Mar 2015 09:36:16 GMT

What is it you do when you "pass the name of country to database"?

Re: Passing value of variable

jonathandienst — Tue, 31 Mar 2015 09:45:52 GMT

Not sure what you are trying to do here, but the variable definition should be

=GetFieldSelections(Country)

where the = is part of the definition. Now $(vCountry) will return the selection.

In a set statement

Set vCountry = =GetFieldSelections(Country);

(the = = is not a typo)

HTH

Jonathan

Re: Passing value of variable

rubenmarin — Tue, 31 Mar 2015 09:51:02 GMT

Hi Swapneel, you can use:

SET vCountry = "=GetFieldSelections(Country)";

Re: Passing value of variable

Tue, 31 Mar 2015 11:39:26 GMT

Hi Ruben Marin,

Thanks for the quick reply but, the solution is not working,

plz find the attached images for reference.

Thanks & Regards

Swapneel

Re: Passing value of variable

Tue, 31 Mar 2015 11:40:27 GMT

HI Jonathan dienst,

thanks for replying, but it didnt work

I am attaching the images for reference.

Thanks again,

Regards

Swapneel

Re: Passing value of variable

Tue, 31 Mar 2015 11:41:09 GMT

I want to achieve dynamic loading.

Regards

Swapneel

Re: Passing value of variable

Tue, 31 Mar 2015 11:45:21 GMT

Hi,

You can use peek function.

LET vAB=Peek(fieldname,0,tablename);

Re: Passing value of variable

rubenmarin — Tue, 31 Mar 2015 11:47:21 GMT

Hi Swapneel, GetFieldSelections() won't work in script, in this case you should do a FOR bucle, ie:

FOR i =0 to NoOfRows('tablesList')-1

LET vTable=Peek('Tables', $(i), 'tablesList');

LOAD *;

SELECT * FROM [DEVS_ID.$(vTable)];

This will load all your tables wich most probably will return a mess of tables. Only way I see this working is if all the tables returned in tablesList have the same fields.

What are you trying to do?

Re: Passing value of variable

avinashelite — Tue, 31 Mar 2015 11:52:57 GMT

Hi,

How your trying to read? that is user will make the selection in the front end of your dashboard and then your trying to push this to DB? if so your variable set should work. But if your trying to capture in the script then we need to think how your doing....can you please answer my questions

Re: Passing value of variable

Tue, 31 Mar 2015 11:54:17 GMT

Hi Ruben Marin,

Thanks for that piece of knowledge .

What I want to do is perform a selective load of only a table that I select.

Where I am stuck at is, I am not able to pass the name of table in string format, its taking directly the formula,

I need something like variableName.Content.GetString & variableName.Content.SetString

I need to do this in scripting, so that I dont need macro.

Hope you can help or atleast provide me with an answer as above explaination.

Thanks & Regards

Swapneel

Re: Passing value of variable

Tue, 31 Mar 2015 11:57:56 GMT

HI Avinash R,

My vision is as follows:

In the front end I am having a list of tables, from which the user can select a table.

This currently selected table should be stored in a variable say vTable,

This vTable variable should be passed in the SQL select command

as Select * from $(vTable).

Thats how I want it.

Thanks & Regards

Swapneel

Re: Passing value of variable

avinashelite — Tue, 31 Mar 2015 12:02:19 GMT

Thanks for the details , Please check with the below document . As per my knowledge it cannot be achieve at the scipt level using your approach . Need go with macro or extension .

SQL Writeback from QlikView extension object.

Re: Passing value of variable

rubenmarin — Tue, 31 Mar 2015 13:04:13 GMT

Hi Swapneel,

You can add a trigger that sets the varaiable value when a Table is selected, then you can use this variable in script.

Another option is create predefined values for this variable and add an input box where user selects in the list the value that the variable will store, variable properties can be those:

Re: Passing value of variable

Wed, 01 Apr 2015 09:23:41 GMT

Thanks for your precious support everyone.

I finally had no option, but to go for the macro approach.

Thanks again, you all have been quick at replies.

Definately count worthy people.

Thanks again.

Regards

Swapneel