topic Re: direct QUERY, problem with tables in QlikView

direct QUERY, problem with tables

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

hi all,

i m trying to use the function of "direct QUERY".

this if the example i done:

table1:

direct QUERY

dimension c1

measure t1_c2,

t1_c3

from t1;

table2:

direct QUERY

dimension c1

measure t2_c2,

t2_c3

from t2;

but the result is this:

why????

Re: direct QUERY, problem with tables

Anil_Babu_Samineni — Tue, 19 Sep 2017 15:27:15 GMT

Are you looking for 2 diff. tables? May be try using NoConcatenate

Re: direct QUERY, problem with tables

Anonymous — Wed, 20 Sep 2017 05:58:24 GMT

hi,

thank you for the replay.

so, yes i m reading from 2 tables, t1 and t2 and i would have the results in 2 different qlikview tables, table1 and table2.

in case, where i sould use NoConcatenate?

Re: direct QUERY, problem with tables

Anonymous — Wed, 20 Sep 2017 07:25:09 GMT

i have tried with a similar example here:

https://community.qlik.com/docs/DOC-6917
(on 3.26)

Re: direct QUERY, problem with tables

Anil_Babu_Samineni — Wed, 20 Sep 2017 15:21:42 GMT

May be here?

table1:

direct QUERY

dimension c1

measure t1_c2,

t1_c3

from t1;

NoConcatenate

table2:

direct QUERY

dimension c1

measure t2_c2,

t2_c3

from t2;

Re: direct QUERY, problem with tables

Anonymous — Thu, 21 Sep 2017 06:04:15 GMT

no,

syntax error....