11 Replies Latest reply: Sep 22, 2017 1:48 AM by Hannes Peiffer RSS

    Mapping Value from Dimension in another Dimension

    Hannes Peiffer

      Hello Qlik-Guys,


      Attached I have a QVW of two tables.


      In the first table I sum up the revenue (Umsatz) per Country(Land) ==> first dimension


      In the second table I sum up the entertainment expenses (Kosten) per Country (Land_Bewirtung) ==> second Dimension


      My Goal is to map the Values from the second Dimension to the first and get rid of the Second Dimension




      For the Country "D" i would like to have only one line (based on the Screenshot)


      D------100 (Umsatz) -------- 180 (Sum of 30 and 150 from the second Dimension where country is "D" and Expression Values)


      I only can do this in the expression, not in the script, as the expression in the original cockpit is quite difficult.


      Any ideas very welcome :-)