7 Replies Latest reply: Oct 13, 2016 9:37 AM by John Blomqvist RSS

    How do I merge two Measure values into one dimensions (by month)? I can only do this using front-end options

    John Blomqvist

      Hi all,

       

      I have a straight table in QlikView like this:

       

       

      Dimension: Month

      Expression 1: Aggr(Sum(LineSalesAmount), Month)

      Expression 2: Aggr(Sum(LineSalesAmountForecast), Month)

       

      (I know I don't have to aggr in the above example but in the real data I have to, the above is just a simplified version).

       

      I would like Expression 1 and 2 to be combined into one expression so that the Sum(LineSalesAmountForecast) values are shown where you see the grey area at the moment.

       

      Does anyone know how to do this please using front-end expressions?

       

      I am not allowed to edit the data model.