topic Re: Setting a Variable Definition In Script in QlikView

Setting a Variable Definition In Script

paul_hallwood — Mon, 12 May 2014 13:42:10 GMT

I'm trying to create a variable within script that will then display this variable in a text box. Currently in the script I have:

SET varData_Status_Year='=[Year] & '/' & ([Year] + 1)';

(where [Year] is the year selected by the user)

The output I am trying to get is e.g. 2013/2014

But when I reload the information and look at the textbox, all I get displayed is the text =[Year] & '/' & ([Year]+1) despite assigning the variable varData_Status_Year to the textbox. It's as if the definition of the variable hasn't been evaluated.

Any ideas warmly welcome. Can I even concatenate existing fields with text to create a variable???

Re: Setting a Variable Definition In Script

Anonymous — Mon, 12 May 2014 13:44:59 GMT

Try this:

SET varData_Status_Year=[Year] & '/' & ([Year] + 1);

Re: Setting a Variable Definition In Script

ashfaq_haseeb — Mon, 12 May 2014 13:45:12 GMT

Hi use let instead of set

LET varData_Status_Year=[Year] & '/' & ([Year] + 1);

Regards

ASHFAQ

Re: Setting a Variable Definition In Script

paul_hallwood — Mon, 12 May 2014 13:50:37 GMT

Hi Michael - just tried that and I get the same as what I was getting previously but without the single quote at the start and end.

Re: Setting a Variable Definition In Script

paul_hallwood — Mon, 12 May 2014 13:52:28 GMT

With your suggestion Ashfaq, I just get a forward slash being displayed in the textbox.

Re: Setting a Variable Definition In Script

Anonymous — Mon, 12 May 2014 13:57:23 GMT

What exactly is in your text box?

varData_Status_Year

=varData_Status_Year

=$(varData_Status_Year)

Re: Setting a Variable Definition In Script

ashfaq_haseeb — Mon, 12 May 2014 14:00:54 GMT

Hi,

Select at least one year.

Regards

ASHFAQ

Re: Setting a Variable Definition In Script

paul_hallwood — Mon, 12 May 2014 14:01:21 GMT

The second one of your options i.e. =varData_Status_Year

I have tried the other two options but they haven't given me what I wanted either.

Re: Setting a Variable Definition In Script

paul_hallwood — Mon, 12 May 2014 14:05:06 GMT

Hi Ashfaq,

I have selected one year and this doesn't change anything unfortunately.

Re: Re: Setting a Variable Definition In Script

Anonymous — Mon, 12 May 2014 14:07:33 GMT

See attached

Re: Setting a Variable Definition In Script

paul_hallwood — Mon, 12 May 2014 14:21:24 GMT

Hi Michael,

Upon looking at your answer I realised where I had gone wrong. I thought I had tried your suggestion of the dollar sign before the brackets, but I think that I was using a different variable at the time. I was using a variable varData_Status_YEAR as opposed to varData_Status_Year.

Just shows you the importance of writing the variable exactly as it is defined. Doh!

Apologies for this guys. Query answered!