Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to load two cross-tables in at a time in qliksense

Hi,

How to load two crosstables in at a time for example like this:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

CrossTable(questions,statement,4)

column17,

column18,

column20,

column21,

how can i load the different questions in two cross-table along with how to concatenate the cross-tables

Thanks,

Suresh

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Hi Arul,

earlier function is working thanks,

Now,

Table1:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

Table2:

CrossTable(Channel,Channelname,4)

column17,

column18,

column20,

column21,

Earlier both tables have the same field names, now its different i want to load the different table in load editor is this possible can you please help on this.

View solution in original post

7 Replies
Highlighted
Master III
Master III

Maybe like this

Table1:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

Table2:

CrossTable(questions,statement,4)

column17,

column18,

column20,

column21,

NoConcatenate 

   

temp:  

load *  Resident Table1;

Concatenate

 

load * Resident Table2;

drop Table Table1;

drop Table Table2;

Highlighted
Contributor II
Contributor II

Hi Arul,

Exactly same thanks,

Regards,

Suresh.

Highlighted
Master III
Master III

is it working?

Highlighted
Contributor II
Contributor II

Yes arul

Highlighted
Master III
Master III

can you close the thread and mark my suggestion as correct

Highlighted
Contributor II
Contributor II

Arul i am in new in this community how to close the threat

Highlighted
Contributor II
Contributor II

Hi Arul,

earlier function is working thanks,

Now,

Table1:

CrossTable(questions,statement,13)

column1,

column2,

column3,

column4,

Table2:

CrossTable(Channel,Channelname,4)

column17,

column18,

column20,

column21,

Earlier both tables have the same field names, now its different i want to load the different table in load editor is this possible can you please help on this.

View solution in original post