Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DS14
Partner - Contributor III
Partner - Contributor III

Cross table in Qliksense

Hi Experts,

I have the data in below format :

Personnel areaName of EE subgroupMar-19 No. of EmpMar-19 GrossApr-19 No. of EmpApr-19 Gross
PA00Management Staff31,00,012.8841,66,897.77
PA00Senior Management1137,35,217.871139,70,239.76
PA01Direct workman256,32,785.98245,97,308.79
PA01ITI/SSLC/GET/DME/TDM00.0000.00
PA01Management Staff103,00,392.40113,64,003.79
PA01Senior Management46,15,864.8247,04,576.27

 

And  I require it in below format : (Cross Table)

Personnel areaName of EE subgroupMonthNo. of EmployeeGross
PA00Management StaffMar-1931,00,012.88
PA00Senior ManagementMar-191137,35,217.87
PA01Direct workmanMar-19256,32,785.98
PA01ITI/SSLC/GET/DME/TDMMar-1900.00
PA01Management StaffMar-19103,00,392.40
PA01Senior ManagementMar-1946,15,864.82
PA00Management StaffApr-1941,66,897.77
PA00Senior ManagementApr-191139,70,239.76
PA01Direct workmanApr-19245,97,308.79
PA01ITI/SSLC/GET/DME/TDMApr-1900.00
PA01Management StaffApr-19113,64,003.79
PA01Senior ManagementApr-1947,04,576.27

 

How I can achieve this .

Help would be appreciated.

Thanks in advance.

 

Labels (4)
1 Reply
kaushiknsolanki

Hi,

Try this.

Data:

Crosstable(Month,NoOfEmployee,2)

Load 

"Personnel area", 
"Name of EE subgroup", 
"Mar-19 No. of Emp" as "Mar-19", 
"Apr-19 No. of Emp" as "Apr-19",

From XYz; 

Concatenate(Data)

Crosstable(Month,Gross,2)

Load 

"Personnel area", 
"Name of EE subgroup", 
"Mar-19 Gross" as "Mar-19", 
"Apr-19 Gross" as "Apr-19"

From XYz; 

Final:

Noconcatenate Load 

"Personnel area",
"Name of EE subgroup", 
Month,

Sum(Gross) as Gross,

Sum(NoOfEmployee) as NoOfEmployee

Resident Data

Group by "Personnel area" 
"Name of EE subgroup" 
Month;

 

Drop table Data;

 

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".