topic Setting a variable in script... in QlikView

Setting a variable in script...

Mon, 17 Jun 2013 12:55:18 GMT

Hi All,

I want to set a varible from code that results in a YTD-like value (in the attached example). I am able to create an expression in a table to get the result. I can also set the variable in the variablescreen and use that to display the desired value, but because of reasons of reusability and the number of variables I need, I want to set the variable in code. This results in an error.

I have tried a lot, but possibly not everything. Maybe some of you guys might be able to come up with a suitable solution.

Kind regards, vBeijnen

Re: Setting a variable in script...

marcus_sommer — Mon, 17 Jun 2013 15:36:54 GMT

It is a difficult matter ... cause are special characters. In most cases it is enough to replace single quotes with double quotes, but here it seems it is the $ sign - see here http://community.qlik.com/message/337484#337484 and also the attachment.

set vFromScript = 'Count({1<Date={"<=#(=max(Date))"}>} Label)';
let vFromScript = replace('$(vFromScript)', '#', chr(36));

- Marcus

Re: Setting a variable in script...

Mon, 17 Jun 2013 15:43:16 GMT

Hi vBeijnein

it is beacause of the $ sign in the string

you have to split up your string like

SET v = first_part_string & chr(36) & second_part_string : chr(36) for $ sign

Idem ifyou use simple/double cotes

best regards

chris

Re: Setting a variable in script...

Mon, 17 Jun 2013 15:47:29 GMT

Thank you kindly, Marcus!

Re: Setting a variable in script...

Tue, 18 Jun 2013 10:07:12 GMT

Thanks, Christianj, Marcus beat you to it... this time.