Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

mousumib
New Contributor

dynamic mapping table in qlik sense desktop version

@can we create dynamic mapping table in qlik sense desktop version? Scenario is created connection from DB A and from excel file B.

In A, project code and department are kept in single table  C and mapping table with type(project/dept) is also there. In table D cost against project and department is there.

From excel file B mapping of department and project code is available but project code and department name in A is not in sync with B. For eg. Department "Global" in A is "Global Share" in B. Same is applicable for project code also.

Can we create a map  table for this in BI tool where "Global" will be mapped with "Global Share"?  Purpose is to find out department/project wise cost calculation If yes then how?