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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

All my queryes go to the same resyult table, am i missing something

Hello

I have one script  with  3 queryes , 

When i load de data i would expect to create c1, c2 and c3, but instad everything goes to c1,   What am I missing ?   (i have used QS but new with QV)

c1 << T_QUERY 13 lines fetched

c1 << T_QUERY 30 lines fetched

c1 << T_QUERY 45 lines fetched

This is part the script

c1:

load

CANT_QRY_1,

CANT_USERS;

sql select

CANT_QRY_1

CANT_USERS

where

CRR_ID_QRY = 1

;

c2:

load

CANT_QRY_2,

CANT_USERS;

sql select

CANT_QRY_2,

CANT_USERS

where

CRR_ID_QRY = 2

;

c3:

load

CANT_QRY_3,

CANT_USERS;

sql select

CANT_QRY_3

CANT_USERS

where

CRR_ID_QRY = 3

;

4 Replies
ogautier62
Specialist II
Specialist II

hi,

may be comma's missing in sql select?

CANT_QRY_1

CANT_USERS

Anonymous
Not applicable
Author

Hi Oliver

No, it is not the ','    i just missed it when i rewrote the example, but it exists in my real query

Thanks

Camilo

settu_periasamy
Master III
Master III

Are you sure, you are using the different field names with these 3 tables?

May be try to use 'No Concatenate' between those tables.

Anonymous
Not applicable
Author

Hello Settu

I added noconcatenate , and it woerked

Thanks!!