Cross table in Qliksense

[DS14]

Hi Experts,

I have the data in below format :

Personnel area	Name of EE subgroup	Mar-19 No. of Emp	Mar-19 Gross	Apr-19 No. of Emp	Apr-19 Gross
PA00	Management Staff	3	1,00,012.88	4	1,66,897.77
PA00	Senior Management	11	37,35,217.87	11	39,70,239.76
PA01	Direct workman	25	6,32,785.98	24	5,97,308.79
PA01	ITI/SSLC/GET/DME/TDM	0	0.00	0	0.00
PA01	Management Staff	10	3,00,392.40	11	3,64,003.79
PA01	Senior Management	4	6,15,864.82	4	7,04,576.27

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

Personnel area	Name of EE subgroup	Month	No. of Employee	Gross
PA00	Management Staff	Mar-19	3	1,00,012.88
PA00	Senior Management	Mar-19	11	37,35,217.87
PA01	Direct workman	Mar-19	25	6,32,785.98
PA01	ITI/SSLC/GET/DME/TDM	Mar-19	0	0.00
PA01	Management Staff	Mar-19	10	3,00,392.40
PA01	Senior Management	Mar-19	4	6,15,864.82
PA00	Management Staff	Apr-19	4	1,66,897.77
PA00	Senior Management	Apr-19	11	39,70,239.76
PA01	Direct workman	Apr-19	24	5,97,308.79
PA01	ITI/SSLC/GET/DME/TDM	Apr-19	0	0.00
PA01	Management Staff	Apr-19	11	3,64,003.79
PA01	Senior Management	Apr-19	4	7,04,576.27

How I can achieve this .

Help would be appreciated.

Thanks in advance.

[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