topic Hi, can someone help concatenate two variables in QlikView

Hi, can someone help concatenate two variables

Tue, 27 May 2014 17:50:08 GMT

Hey hey

I need some help concatenate two variables.(not sure if this is the correct way to describe my issue, still new to QV, please bear with me).

Basically I have two variables, vOpr and vNum. vOpr is used to store operators, like <, > or =, while vNum is used to allow user to enter number.

For example, if I want to see a listing of users with Hours_Charged more than 10. I should be able to select vOpr as '>' and specify vNum as 10. But I'm not quite sure how to define the dimension. Right now I have =if([Hours Charged]&$(vOpr+vNum),Client)... and it doesn't give me the correct results...

Please see attachment for details.

Thanks in advance.

Dorothy

Re: Hi, can someone help concatenate two variables

Anonymous — Tue, 27 May 2014 18:06:13 GMT

Dorothy, try attached. The calculated dimension is:

if([Hours Charged] $(vOpr) $(vNum),Client)

(I had a minor trouble with the '=' sign, I hope you'll figure out. Maybe you don't need it...)

Re: Re: Hi, can someone help concatenate two variables

Tue, 27 May 2014 18:16:29 GMT

From what Michael posted - you can use spaces to trick QV into using the dollar sign. See attached.

Re: Hi, can someone help concatenate two variables

Wed, 28 May 2014 03:11:40 GMT

Thank you so much Micheal, this is really helpful!!

Re: Hi, can someone help concatenate two variables

Wed, 28 May 2014 03:13:24 GMT

Thank you Rebecca, work like a charm

Re: Hi, can someone help concatenate two variables

Wed, 28 May 2014 13:43:12 GMT

Please mark Michael's answer as Correct and mine as Helpful. Thanks!

Re: Hi, can someone help concatenate two variables

Anonymous — Wed, 28 May 2014 13:49:22 GMT

I guess Dorothy knows better how to mark the answers

Re: Hi, can someone help concatenate two variables

Wed, 28 May 2014 14:05:50 GMT

Didn't intend to hijack your thread!!!

Re: Hi, can someone help concatenate two variables

Anonymous — Wed, 28 May 2014 14:09:26 GMT

No problem, it's not a private message after all