Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
berryandcherry6
Not applicable

Building table using Hypercubes in qliksense Mashups

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

2 Replies
balrajahlawat
Not applicable

Re: Building table using Hypercubes in qliksense

You expression did not work?

berryandcherry6
Not applicable

Re: Building table using Hypercubes in qliksense

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?