topic Re: Filters on objects using Qlik Engine APIs in Integration, Extension & APIs

Filters on objects using Qlik Engine APIs

Anonymous — Mon, 12 Feb 2018 12:22:37 GMT

I want to apply filters on Qlik object to get Hypercube Data of a selected rows and columns by values, not by Rows and Column Index numbers.

e.g.

I want to get a filtered object by Column name "L3" for value "ERS-SDES-IOT" and rows and column indexes are variable.

What i tried so far is :-

{

"method": "SelectHyperCubeCells",

"handle": 3,

"params": [

"/qHyperCubeDef",

[ 1 ],

[ 1 ]

"id": 4,

"jsonrpc": "2.0"

}

But it allows me filter Objects only by row and column index numbers. My question is how to get filtered table using values?

Re: Filters on objects using Qlik Engine APIs

ErikWetterberg — Mon, 12 Feb 2018 18:22:43 GMT

Hi,

The most common way to do this is with SelectHyperCubeValues SelectHyperCubeValues method ‒ Qlik Sense Developers

In your case you would use the index of the L3 field and the qElemNumber of the value you want to select.

You could also use field methods:

- LowLevelSelect method ‒ Qlik Sense Developers

- SelectValues method ‒ Qlik Sense Developers

But they would only work if the dimension is a field.

Hope this helps you

Erik Wetterberg

Re: Filters on objects using Qlik Engine APIs

Anonymous — Tue, 13 Feb 2018 06:52:17 GMT

Thanks for your reply. Would you please help me on how to get qElemNumber of a value before fetching the data because i wil only fetch hypercube data after applying fllters.

Re: Filters on objects using Qlik Engine APIs

ErikWetterberg — Tue, 13 Feb 2018 07:02:33 GMT

Hi,

As far as I know that's not possible, but you could use field.selectValues. How do you know that there is such a thing as "ERS-SDES-IOT" without actually fetching the values for L3?

Erik Wetterberg

Please mark as correct and/or helpful if this is any help for you