topic Where in table inline in QlikView

Where in table inline

Wed, 18 May 2011 15:09:57 GMT

Hi, I do this and works well

Ciudades:

LOAD * INLINE [

Ciudad, Valor

Barcelona, X

Tarragona, M

Lleida, N

Girona, P ] where Ciudad='Barcelona' ;

But, if change 'Barcelona' by variable, malfunctions

LET var='Barcelona';

Ciudades:
LOAD * INLINE [
    Ciudad, Valor
    Barcelona, X
    Tarragona, M
    Lleida, N
    Girona, P ] where Ciudad=$(var);

Can help me?

Thanks...

Where in table inline

pat_agen — Wed, 18 May 2011 15:16:47 GMT

hi,

try simple quotes around the variable

Servidor='$(var)'

Where in table inline

erichshiino — Wed, 18 May 2011 15:17:10 GMT

Try this:

Ciudades:

LOAD * INLINE [

Ciudad, Valor

Barcelona, X

Tarragona, M

Lleida, N

Girona, P ] where Servidor='$(var)';

( ... but it is a bit strange that you used where since you wrote the inline yourself...)

Hope it helps,

Erich

Where in table inline

Wed, 18 May 2011 15:36:32 GMT

Thanks a lot, Pat and Erich