direct QUERY, problem with tables

[Anonymous]

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

[Anil_Babu_Samineni]

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

[Anonymous]

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?

[Anonymous]

i have tried with a similar example here:

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

[Anil_Babu_Samineni]

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;

[Anonymous]

no,

syntax error....