Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Highlighted
Partner
Partner

Always create hypercube on full data set (ignore filters)

Hi,

I'm building a mashup that uses data from multiple hypercubes.

A few of those hypercubes should only be created once, when the page loads. The data is used to create menu's that should remain static after initial creation.

I managed to do this by calling the function like this, so that it is ran only once:

app.createCube({ ... }).then(function(reply){ build the menu })

When the page is refreshed all filters are cleared before the cube is recreated, but sometimes the cube only returns the filtered values.

My question: is there a way to make sure that all filters are ignored when creating the cube?

Thanks!

1 Solution

Accepted Solutions
ErikWetterberg
Honored Contributor

Re: Always create hypercube on full data set (ignore filters)

Hi,

You could use set analysis in you hypercubes. Or make sure the menu data is on a separate data island, not connected to the fields available in filters.

Erik Wetterberg

3 Replies
ErikWetterberg
Honored Contributor

Re: Always create hypercube on full data set (ignore filters)

Hi,

You could use set analysis in you hypercubes. Or make sure the menu data is on a separate data island, not connected to the fields available in filters.

Erik Wetterberg

Partner
Partner

Re: Always create hypercube on full data set (ignore filters)

Hi,

Thanks for that! Do you know how I can put a hypercube on a separate data island?

Partner
Partner

Re: Always create hypercube on full data set (ignore filters)

Oh nevermind, I get what you mean. But the menu data has to remain connected to the other dimensions.

I will try with set analysis