1 Reply Latest reply: Apr 12, 2017 9:37 AM by James Phillips RSS

    Issue with pivot hypercube in a mashup

    James Phillips

      I'm trying to create a pivot hypercube with two dimensions in a mashup, but I can't get it to use the second dimension, it just sums by the first one.

      I created the hypercube using the Hypercube builder.

      Am I doing something wrong or is this a limitation of Qlik Sense?

       

      Input data -

      OptionDurationValue
      A10.1
      A21.5
      A32
      B21.25
      B32.1
      C21.6

       

      What I want -

      Option123
      A0.11.52
      B1.252.1
      C1.6

       

      What I get -

      OptionSum(Value)
      A3.6
      B3.35
      C1.6