topic Syntax to Concat two variables in another variable in QlikView

Syntax to Concat two variables in another variable

oakes_gco_qlik — Fri, 20 Jun 2014 11:29:28 GMT

I have three variables vStartMM vStartYY vSTARTMMYY within vStartmm and vStartYY I have fields which change based on selections made (they are ok). What I require is to take these two variables and concatenate them into one variable vSTARTMMYY.

Within the Variable Overview - Definition- I am using the CONCAT function. I have looked high and low for just one example that would be of use and I cannot find one - ANYONE help please.

Re: Syntax to Concat two variables in another variable

alexandros17 — Fri, 20 Jun 2014 11:32:48 GMT

LET vStartMM = ....

LET vStartYY = ...

LET vSTARTMMYY = $(vStartYY)$(vStartMM);

let me know

Re: Syntax to Concat two variables in another variable

swuehl — Fri, 20 Jun 2014 11:33:56 GMT

You can use the concatenation operator & instead to concatenate two strings:

=vStartMM & vStartYY

Re: Syntax to Concat two variables in another variable

oakes_gco_qlik — Fri, 20 Jun 2014 11:43:21 GMT

Thank you but I am thinking this would be ok in the script but inside the variable Overview (Definition)its not working.

Re: Syntax to Concat two variables in another variable

oakes_gco_qlik — Fri, 20 Jun 2014 11:44:45 GMT

Looks like I didnt need 'concat' any way - no wonder I couldnt get it to work. This has resolved my problem. Thankyou.

Re: Syntax to Concat two variables in another variable

oakes_gco_qlik — Fri, 20 Jun 2014 14:27:53 GMT

Hi me again- I am very close to my solution just one little problem. When I concatenate the two variables (one of which is month) the value is a single digit for Jan to Sept where I need it to be two digits ie 01 for Jan up to 09 for Sept.

My selections and subsequent analysis works ok when I select Oct Nov Dec. as they are 10 11 12.

Any suggestions??

Re: Syntax to Concat two variables in another variable

anbu1984 — Fri, 20 Jun 2014 14:29:46 GMT

Right('0'&Month_var,2)

Re: Syntax to Concat two variables in another variable

alexandros17 — Fri, 20 Jun 2014 14:30:03 GMT

Num(vStartMM,'00')

Re: Syntax to Concat two variables in another variable

oakes_gco_qlik — Fri, 20 Jun 2014 14:38:43 GMT

Thanks guys much appreciated.