topic Re: Expression, String Issue in QlikView

Expression, String Issue

sibin_jacob — Tue, 05 Mar 2013 15:48:33 GMT

Hai ,

I have a expression problem. Below is my expression.

1. Only({<Physician_Name={'sibin jacob'}>}IMS_Number)

2. Only({<Physician_Name={$(vFirst_Physician)}>}IMS_Number)

I am gettong right value in the first expresion. But the second one not getting any value.

My variable value is 'sibin jacob'. I tried with 'sibin*jacob' but not getting any value.

When Physician name containing space I am not getting any value.

How will I change the expression to get the right value using variable?

Thanks,

Sibin Jacob.C

Gysbert_Wassenaar — Tue, 05 Mar 2013 15:50:57 GMT

Since it's a string you need single quotes around the variable expansion:

Only({<Physician_Name={'$(vFirst_Physician)'}>}IMS_Number)

sibin_jacob — Tue, 05 Mar 2013 16:13:44 GMT

Thanks Man...