Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator III
Creator III

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
Anonymous
Not applicable

You expression did not work?

berryandcherry6
Creator III
Creator III
Author

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?