Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to join two CrossTables with different statement

Hi,

How to join two cross tables with different statement for Ex:

Table1:

CrossTable (Questions,Statement,13)

LOAD

   customer id;

   age;

   gender;

   occupation;

   Month;

     ex: [Q1]

     ex: [Q2]

     ex: [Q3]

     ex: [Q4]

     ex: [Q5]

FROM [lib://Unpivot /sample.xlsx]

(ooxml, embedded labels, table is Data);

Table2:

CrossTable (Channel,Channel_Name,13)

LOAD

   customer id;

   age;

   gender;

   occupation;

   Month;

     ex: [R1]

     ex: [R2]

     ex: [R3]

     ex: [R4]

     ex: [R5]

FROM [lib://Unpivot /sample.xlsx]

(ooxml, embedded labels, table is Data);

how to join this two crosstables in load editor can anyone please help me on this.