Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
suresherks
New 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
suresherks
New Contributor II

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

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
arulsettu
Honored Contributor III

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

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;

suresherks
New Contributor II

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

Hi Arul,

Exactly same thanks,

Regards,

Suresh.

arulsettu
Honored Contributor III

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

is it working?

suresherks
New Contributor II

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

Yes arul

arulsettu
Honored Contributor III

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

can you close the thread and mark my suggestion as correct

suresherks
New Contributor II

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

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

suresherks
New Contributor II

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

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