topic Re: Merge two string variables into one in QlikView

Merge two string variables into one

annabergendal — Wed, 29 Oct 2014 23:35:26 GMT

I want to create a variable with two other variables, year and previous week.

=$(vYear) &' - '& $(vPreviousWeek)

It doesn't work though, what is the syntax? I want it to be for example "2014-39"

Thanks

Re: Merge two string variables into one

maxgro — Wed, 29 Oct 2014 23:51:02 GMT

it depends on how you define vYear and vPreviousWeek

example, with this in an input box

vYear =max(Year) // field Year

vPreviousWeek =max(Week) // field Week

v =$(vYear) & '-' & $(vPreviousWeek)

you get

Re: Merge two string variables into one

danieloberbilli — Thu, 30 Oct 2014 00:07:58 GMT

And you have to do it in the variable-window of the frontend - not in the script as you have to replace the $-signs to avoid QV in executing them unintentional

Re: Merge two string variables into one

annabergendal — Thu, 30 Oct 2014 07:38:15 GMT

vYear = Year($(vToday)) and same for vWeek.

Should I define withuot '$' ? But it doesn't work without...

With the syntax =$(vYear) & '-' & $(vPreviousWeek) I get 1976 when vYear is 2014 and vWeek is 39.

Re: Merge two string variables into one

vardhancse — Thu, 30 Oct 2014 07:42:58 GMT

=$(vYear) & ' - ' & $(vPreviousWeek)

Re: Merge two string variables into one

danieloberbilli — Thu, 30 Oct 2014 07:46:05 GMT

seems that vPreviousWeek is also defined as year - thats why it substracts 39 years. Try Week() instead of Year

Re: Merge two string variables into one

Thu, 30 Oct 2014 07:47:30 GMT

Anna,

Pls share your complete variable logic & it depend on the logic being user there.normally if you variable having year

To use that varable, following is the syntax

$(variablename) or $(=variablename)

yoy can use eaither of those two.

Re: Merge two string variables into one

annabergendal — Thu, 30 Oct 2014 07:48:25 GMT

Thanks, I think this was actually my problem, when using the created variable in a script I used $, when I take that away it works

Re: Merge two string variables into one

Thu, 30 Oct 2014 08:34:51 GMT

I look at your statement: vYear = Year($(vToday)) and same for vWeek

If you store "Today" date in a variable and then put it, as a date field, in other date function (Year($(Today)) in your case) that function may have a problem to convert your $(Today) variable.

To solve this you can replace

Year ($ (vToday))

with the syntax:

Year (Today ()).

Today() function will be converted correctly by Year() function.

The same for the week function.