Building table using Hypercubes in qliksense Mashups

[berryandcherry6]

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

[Anonymous]

You expression did not work?

[berryandcherry6]

Its fine in qliksense, but i need to build it in Mashups. How could i put a code using Hypercube in expression,

i have seen many links related to piechart with hypercube, but i need to built table with hypercube?

Any links or sample?