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: 
Anonymous
Not applicable

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?

0 Replies