Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Help with syntax

Sql select
movie_id,
movie_title,
movie_genre
from ...... ;

Sql select
movie_id,
customer_id,
country,
country_id
from ...... ;

Sql select
country_id,
movie_language
from ......

I want to create a list where I can only see the movies where the language is DUTCH (if the country_id = 1) and the language is GERMAN (if the country_id = 2) and the language is OTHER (when movie_genre is = 'soap')

I've tried a few syntaxes but can't get the right one. What is the right code and where do i have to paste it? (in the listproperties or in the codepage?)

1 Reply
Not applicable

Help with syntax

Without knowing the names of your tables:


Sql select
movie_id,
movie_title,
movie_genre
from Table1;

Sql select
movie_id,
customer_id,
country,
country_id
from Table2 ;
Sql select
country_id,
movie_language
from Table3;

Sql Select Table1.movie_title, Table3.movie_language from
Table1 inner join Table2 on Table1.movie_id = Table2.movie_id
inner join Table3 on Table2.country_id = table3.Country_id
where table3.movielanguage in ('DUTCH', 'GERMAN', 'OTHER')


Community Browser