topic Re: Variable value with space is used in expression in QlikView

Variable value with space is used in expression

kinjal1645 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have following variables:

vref1=If(GetPossibleCount(p1_ref)=1,p1_ref)

vP1val=If(GetPossibleCount(p1_value)=1,p1_value)

vref2=If(GetPossibleCount(p2_ref)=1,p2_ref)

vP2val=If(GetPossibleCount(p2_value)=1,p2_value)

output of these variables for one case:

vref1= ca_1

vP1val= not configured

vref2= ca_xa

vP2val= 2A

These variables are used in calculated dimension of straight table:

=aggr(Only({$<$(vref1)={$(vP1val)},$(vref2)={$(vP2val)}>} m_field),m_field)

But I am getting blank table for these selections because there is space in "not configured"

When I change vP1val = configured then table is populated with values.

Let me know how to handle this i.e. when there is space in variable value and used in expression.

Kindly help!

Thanks

sunny_talwar — Thu, 24 May 2018 16:38:33 GMT

Add single quotes around your variable in set analysis

=Aggr(Only({$<$(vref1) = {'$(vP1val)'}, $(vref2) = {'$(vP2val)'}>} m_field), m_field)

kinjal1645 — Thu, 24 May 2018 16:43:55 GMT

Thanks! That was quick

kinjal1645 — Thu, 24 May 2018 18:10:51 GMT

Can you let me know what does single quotes indicate?

sunny_talwar — Thu, 24 May 2018 18:17:58 GMT

that you have a literal between two single quotes