topic Re: String value into a variable. in QlikView

String value into a variable.

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Can anyone help me with a Syntax for the below. Thanks in Advance.

How to assign the string value into a variable.

Example: x="apple". Here x is a variable name.

Regards,

Pooja.

Re: String value into a variable.

sunny_talwar — Mon, 23 May 2016 16:25:14 GMT

Try this LET x = 'apple';

Re: String value into a variable.

Mon, 23 May 2016 18:42:31 GMT

Hi Sunny,

Thanks for the response but , I am not getting the answer. It shows "-" in the text object when i called that variable.

Regards,

Pooja.

Re: String value into a variable.

sunny_talwar — Mon, 23 May 2016 19:20:08 GMT

Would you be able to share the application to check it out?

Re: String value into a variable.

MarcoWedel — Mon, 23 May 2016 23:06:30 GMT

Hi,

maybe you can see the difference to Sunny's suggested solution in your application?:

LET x = 'apple';

hope this helps

regards

Marco

Re: String value into a variable.

clondono — Mon, 23 May 2016 23:51:30 GMT

If you don't want to declare it in the load script, you can create a variable, you can update the variable with an input box

Re: String value into a variable.

rwunderlich — Tue, 24 May 2016 01:00:04 GMT

Make sure you used single (not double) quotes as Sunny specified.

For this assignment, you can also make it even simpler by using SET.

SET x=apple;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: String value into a variable.

Tue, 24 May 2016 02:09:46 GMT

Hi Sunny,

I have attached the qvw file. And let me know the possible solution.

Actual expectation is:

LET v=10;

LET x='apple';

Result in Text Object should be: 10 apple

Thanks,

Pooja

Re: String value into a variable.

sunny_talwar — Tue, 24 May 2016 02:22:05 GMT

Try this:

=v&' ' & x

Re: String value into a variable.

Tue, 24 May 2016 02:36:19 GMT

Hi Sunny,

Thanks for your quick response. Got the result as expected. I like to know the difference between defining the variable in script level and in design level(settings->variable overview).

Thanks in Advance,

Pooja

Re: String value into a variable.

sunny_talwar — Tue, 24 May 2016 03:04:08 GMT

When the variable is a static value (like apple, 10, etc)

The biggest difference is that the one in the script will change to the value specified in the script (unless within an if statement) whereas once that are on the front end won't change based on a refresh. You can always create the variable in the script and remove them after creating them from avoiding to reset there value everytime you run your script.

When variable is an expression: Sum(Sales)

Its just a matter of preference, I sometimes do it in scrip, or even in an Excel file (Storing variables outside of QlikView - The Qlik Fix! The Qlik Fix!). But mostly on the front end for no specific reason.

Re: String value into a variable.

Tue, 24 May 2016 14:37:21 GMT

Hi Sunny,

Thank you so much.

Regards,

Pooja