Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where in table inline

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

1 Solution

Accepted Solutions
pat_agen
Specialist
Specialist

hi,

try simple quotes around the variable

Servidor='$(var)'

View solution in original post

3 Replies
pat_agen
Specialist
Specialist

hi,

try simple quotes around the variable

Servidor='$(var)'

erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

Thanks a lot, Pat and Erich