topic Loading string value to a variable from table in QlikView

Loading string value to a variable from table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to know how to store a field value i.e string in a variable.

Ex:

table:

id,name

1,aaa

2,bbb

3,ccc

how to load the filed values into a variable??

I tried peek function let vname = peek('name',0,'table')

but I didn't get any answer

If I keep id field instead of name I got result for id.

Please give the solution for this.

Re: Loading string value to a variable from table

avinashelite — Wed, 04 Oct 2017 11:42:31 GMT

If I understand , you want to load the filed values into variable ...try this in front end

vname

=concat( distinct name, ';' )

Re: Loading string value to a variable from table

Anonymous — Wed, 04 Oct 2017 11:51:32 GMT

Hi mallika,

Try:

Let vname = peek(name,0,'table');

(without enclosing name in single quotes)

That should do the trick.

Re: Loading string value to a variable from table

Anonymous — Wed, 04 Oct 2017 12:56:58 GMT

I try this .but not getting answer

Re: Loading string value to a variable from table

rwunderlich — Wed, 04 Oct 2017 13:06:45 GMT

You should use single quotes in the field name.

Let vname = peek('name',0,'table');

should work as long as table exists and has a field called name.

Can you post your script log?

-Rob

Re: Loading string value to a variable from table

Anonymous — Wed, 04 Oct 2017 13:24:10 GMT

Try This

=GetCurrentSelections(name )

Re: Loading string value to a variable from table

jayshrinipurte — Wed, 04 Oct 2017 13:29:55 GMT

Hi Mallika,

Try to use FirstSorted Value Function....

Let vName = Firstsortedvalue(Name,0)

Regards,

Jayshri

Re: Loading string value to a variable from table

Kushal_Chawda — Wed, 04 Oct 2017 13:35:43 GMT

what you want to achieve? If you can tell us your exact requirement, we can suggest some other ways

Re: Loading string value to a variable from table

Anonymous — Thu, 05 Oct 2017 05:05:57 GMT

its work fine

set vname=SubField(name,',');

regards

sahadev

Re: Loading string value to a variable from table

Anonymous — Mon, 23 Oct 2017 09:52:00 GMT

yes I got it.

Thank you