0 Replies Latest reply: Nov 29, 2017 1:36 AM by Mousumi Bhowmick RSS

    dynamic mapping table in qlik sense desktop version

    Mousumi Bhowmick

      @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?