Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
From what Michael posted - you can use spaces to trick QV into using the dollar sign. See attached.
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...)
From what Michael posted - you can use spaces to trick QV into using the dollar sign. See attached.
Thank you so much Micheal, this is really helpful!!
Thank you Rebecca, work like a charm
Please mark Michael's answer as Correct and mine as Helpful. Thanks!
I guess Dorothy knows better how to mark the answers
Didn't intend to hijack your thread!!!
No problem, it's not a private message after all