Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kaviyarasan
Contributor
Contributor

Qliksense Crosstable

I want to concatenate the two cross-table.But i facing some trouble while concatenate

Table A:

CrossTable("KPI Name", "KPI Value",7)

Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(A-B)/A as "1.1.2 WDMD: Interface - Records With No HR Data Issue Fallout (%)",
(F-E)/F as "1.2.2 WDMD: Automated Data (%)",
(H-J)/H as "1.3.2 WDMD: New Hires - 1st Load Attempt Success (%)",
I/H as "1.3.4 WDMD: New Hires - Load Success Overall (%)",
L/K as "1.3.6 WDMD: New Hires - Employee Load Timeliness (%)",
(P-O)/P as "3.1.2 OTP: Interface - Records With No HR Data Issue Fallout (%)",
(P-S)/P as "3.2.1 OTP: Corrections vs Total Records (%)" 

from source

Table B:

CrossTable("KPI Name", "KPI Value",8)

Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(vpbB/vpbA) as "4.1.1 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Timeliness (%)",
(vpbE-vpbF)/vpbE as "4.1.2 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Accuracy (%)",
vpbD/vpbC as "4.1.3 VPB/PFR: Interface - File Delivery: Timeliness (%)",
vpbH/vpbG as "4.1.4 VPB/PFR: Interface - File Delivery: Accuracy (%)",
(vpbG-vpbJ-vpbK-vpbL)/vpbG as "4.2.1 VPB/PFR: Corrections - Record Accuracy (%)",
vpbO/(vpbJ+vpbK+vpbL) as "4.2.2 VPB/PFR: Corrections - Loaded (%)",
(vpbM-vpbN)/vpbM as "4.2.3 VPB/PFR: Stop Payment Request Volumes (%)",
vpbP/vpbN as "4.2.4 VPB/PFR: Corrections - Stop Payments Processed (%)"

from source

----

case 1: If i keep Column qualifier both Table A & Table B is 7 

Then its show some error

case 2:if i keep column qualifier table A=7 and table B=8

its concatenate well ,but its skip the line (vpbB/vpbA) as "4.1.1 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Timeliness (%)", from table B

 

Thanks in Adavnce

 

 

 

1 Reply
jyothish8807
Master II
Master II

Hi Kavi,

Try like this:

Table A:

CrossTable("KPI Name", "KPI Value",7)

Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(A-B)/A as "1.1.2 WDMD: Interface - Records With No HR Data Issue Fallout (%)",
(F-E)/F as "1.2.2 WDMD: Automated Data (%)",
(H-J)/H as "1.3.2 WDMD: New Hires - 1st Load Attempt Success (%)",
I/H as "1.3.4 WDMD: New Hires - Load Success Overall (%)",
L/K as "1.3.6 WDMD: New Hires - Employee Load Timeliness (%)",
(P-O)/P as "3.1.2 OTP: Interface - Records With No HR Data Issue Fallout (%)",
(P-S)/P as "3.2.1 OTP: Corrections vs Total Records (%)" 

from source

Table B:

CrossTable("KPI Name", "KPI Value",8)

Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(vpbB/vpbA) as "4.1.1 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Timeliness (%)",
(vpbE-vpbF)/vpbE as "4.1.2 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Accuracy (%)",
vpbD/vpbC as "4.1.3 VPB/PFR: Interface - File Delivery: Timeliness (%)",
vpbH/vpbG as "4.1.4 VPB/PFR: Interface - File Delivery: Accuracy (%)",
(vpbG-vpbJ-vpbK-vpbL)/vpbG as "4.2.1 VPB/PFR: Corrections - Record Accuracy (%)",
vpbO/(vpbJ+vpbK+vpbL) as "4.2.2 VPB/PFR: Corrections - Loaded (%)",
(vpbM-vpbN)/vpbM as "4.2.3 VPB/PFR: Stop Payment Request Volumes (%)",
vpbP/vpbN as "4.2.4 VPB/PFR: Corrections - Stop Payments Processed (%)"

from source;

Noconcatenate

Tab1:

Load *

resident Table A;

concatenate (Tab1)

Load

*

resident Table B;

Drop tables TableA,Table B;

Best Regards,
KC