topic Re: Engine API selecting a field value in Integration, Extension & APIs

Engine API selecting a field value

andyjalexlive — Sat, 16 Nov 2024 03:23:55 GMT

Hi,

I've recently started to create Mashups using the Engine API. Can someone tell me how i select a value of a field in the Qlik sense app using the Engine API?

e.g. I have a field in my Qlik Sense App called CustomerID and i want to select where CustomerID = 1

Many thanks

Andy

Re: Engine API selecting a field value

ErikWetterberg — Fri, 31 Jan 2020 15:09:32 GMT

Use GetField to get a field object, then there are some different methods:

SelectValues if you have the exact value
LowLevelSelect if you know the index
Select if you want to use wildcards etc

Re: Engine API selecting a field value

andyjalexlive — Wed, 05 Feb 2020 22:47:12 GMT

Thanks for your reply Eric

I'm trying this but to no avail

app.getField('CustomerID ')
.then((result) => result.selectValues(10000067)
)

error :

JSON parse error
at Intercept.errorResponseInterceptor (error-response-interceptor.js:1

Do you know what i'm doing wrong?

Thanks
Andy

Re: Engine API selecting a field value

beatYesterday — Wed, 17 Feb 2021 21:49:27 GMT

@ErikWetterberg ,

I am able to run the SelectValues after selecting a field in my app, and qReturn= true on response. However, the table objects in my App are not filtered at all. Are you able to explain how I can use this SelectValues method and then apply the field selections as a filter to an entire sheet or to a specific table object? Thank you.

Re: Engine API selecting a field value

andyjalexlive — Thu, 18 Feb 2021 17:20:46 GMT

After selectValues you need to get the result and then invoke a promise to reload your other objects. e.g.

let exampleVisualisationRender= new exampleVisualisation(exampleData)

...

object.selectValues( [
{qText: "1234", qIsNumeric: true, qNumber: 1234}

]).then((result) =>{

Promise.all([ExampleData.open()]).then(() => {
exampleVisualisationRender.init()

})})

Hope that helps

Andy

Re: Engine API selecting a field value

ErikWetterberg — Wed, 24 Feb 2021 06:04:58 GMT

The first parameter should be an array.

Re: Engine API selecting a field value

beatYesterday — Tue, 02 Mar 2021 17:17:47 GMT

Thanks, @andyjalexlive This reply helped a lot. For other newcomers like myself while I read the documentation I did not realize a couple of things that prevented the SelectValues method from actually being applied. Below are the points I (finally) figured out to solve this:

Dates are stored as numeric values in Qlik. This means if you are trying to filter by a date formatted like '2021/02/01'(YYYY-MM-DD), then you need to convert that into it's numeric value. This numeric value is calculated in teh same way as in Excell, meaning it's just an incremental count of days since 1/1/1900. A simple google search will provide details for how to do this.

When you are selecting a numeric value, that select match does NOT go in the qText attribute. Rather, you set qIsNumeric = True AND send the numeric value in the qNumber attribute. (This is what was my specific problem that I originally outlined above)