Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

tversweyveld
New Contributor III

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
erik_wetterberg
Valued Contributor III

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

Erik Wetterberg
https://extendingqlik.upper88.com/
3 Replies
erik_wetterberg
Valued Contributor III

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

Erik Wetterberg
https://extendingqlik.upper88.com/
tversweyveld
New Contributor III

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?

tversweyveld
New Contributor III

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

Community Browser