Hi, can someone help concatenate two variables

[#1]

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

[Anonymous]

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...)

[#3 · Accepted solution]

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

[#4]

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

[#5]

Thank you Rebecca, work like a charm

[#6]

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

[Anonymous]

I guess Dorothy knows better how to mark the answers 

[#8]

Didn't intend to hijack your thread!!!

[Anonymous]

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