2 Replies Latest reply: Sep 29, 2016 6:51 AM by Supriya R RSS

    Building table using Hypercubes in qliksense Mashups

    Supriya R

      Hi,

       

      I am trying to build a table using Hypercubes with multiple expression.

       

      In qliksense i have

       

       

      Dimension: FruitMetrics

       

      Where FruitMetrics is

      FruitMetrics:

      LOAD * INLINE [

            FruitMetrics

      Mango

      Apple

      Orange

          Total

      ];

       

      Expressions:

      if(FruitMetrics='Mango',Count(Mango),

      if(FruitMetrics='Apple',Count(Apple),

      if(FruitMetrics='Orange',Count(Orange),

      if(FruitMetrics='Total',Count(Mango)+Count(Apple)+Count(Orange)))))

       

       

      Please help me on this