topic Re: Show two pivot tables in one in QlikView

Show two pivot tables in one

Fri, 27 Jul 2012 16:18:45 GMT

Grettings, I have a problem with a pivot table, rather, with the fields of that tables.

We have two important fields in my model, TermReason and RecruitType, in both fields, I wes create a pivot table that show the numeric count of the Employees (GlobalEmployeeId), and show it by months, like this image:

This is no problem, is very easy create these pivot tables, but I need to add/fuse/join/etc this table and makes them one table. The problem, the distinct source of the tables, because TermReason and RecruitType are in different table, both in Qlikview and in SQL Server. Joins in Qlikview and in SQL Server doesn't work, and I no have any idea that I can do for resolve this problem.

I attach the .qvw fiel with my model if someone can help me. By the way, I don't have the professional license of Qlikview, only Personal Edition, I won't can see your files, so I would so glad if you can wrote the code or show me a image.

Beforehand, thanks you for you answers and sorry for my poor level of english.

P.D: I speak spanish, it's my native language, so if someone wants reply in spanish, no problem for me

Re: Show two pivot tables in one

Fri, 27 Jul 2012 19:27:07 GMT

Add the following at the end of your script:

MapRecruitmentTypeId: Mapping LOAD RecruitmentTypeId,RecruitType Resident DimRecruitmentType;

MapTerminationReasonId: Mapping LOAD TerminationReasonId,TermReason Resident DimTerminationReason;

DIMRecruitTermination:

LOAD GlobalEmployeeId,ApplyMap('MapRecruitmentTypeId',RecruitmentTypeId) as RecruitTermination Resident FactEmployee;

Concatenate

LOAD GlobalEmployeeId,ApplyMap('MapTerminationReasonId',TerminationReasonId) as RecruitTermination Resident FactEmployee;

Use same expression with RecruitTermination as dimension. Then go to dimensions tab of the chart and "suppress when value is null" for RecruitTermination.

Regards,

Kiran Rokkam.

Re: Show two pivot tables in one

Fri, 27 Jul 2012 21:53:22 GMT

Thank you Kiran, that is all that I need it, thank you very much