topic Re: Filter hypercube by several fields(dimensions) in Integration, Extension & APIs

Filter hypercube by several fields(dimensions)

alexrusin — Sat, 16 Nov 2024 06:23:47 GMT

Hi All

Could you please advice, how I can filter hypercube object by several fields?

For example I created HyperCube(by Engine API Explorer) with dimensions City and Year. And from qMatrix array I need get only Meansures where for example City = York and Year = 2000.

Is present some way to filter HyperCube by several dimensions?

Thanks!

Re: Filter hypercube by several fields(dimensions)

rwunderlich — Thu, 07 Mar 2019 15:20:34 GMT

In your Measure def, use a set expression to limit by your criteria. For example:

=sum({<City={'York'}, Year={2000}>} Sales)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Filter hypercube by several fields(dimensions)

alexrusin — Thu, 07 Mar 2019 15:46:49 GMT

Thanks, solution work as well!

Re: Filter hypercube by several fields(dimensions)

Gappodi — Thu, 07 Mar 2019 16:06:36 GMT

Rob,
Is there a way to set these selections through some structures (like Generic Object with qListObjectDef or Field Class with Select Method)?
Thanks

Re: Filter hypercube by several fields(dimensions)

rwunderlich — Thu, 07 Mar 2019 16:18:09 GMT

You could make the selections using one of the select methods and then the hypercube would reflect those selections. I'm not aware of a structure you could include in the hypercube def, but I would not be surprised if there is a way. I'm always learning something new about the Engine API.

-Rob