topic Re: Programatically selecting range of data in Integration, Extension & APIs

Programatically selecting range of data

Anonymous — Fri, 07 Sep 2018 21:58:13 GMT

Hey,

I am currently working on a project where I require the functionality to programmatically select data from a qlik object. I am doing this using the selectValues combined with the data from a field which works great for single items/strings, however, when I want to filter a list of dates, for example, I cannot get this to work.

Is there a way that I can use the selectValues method to query this data? I've tried building an array with the dates ['03/01/2018, 04/01/2018'] however this did not work.

Alternatively, I am open to suggestions on how I can save the state of currentSelectionItems, I have looked over the documentation but cannot seem to find anything suitable.

Re: Programatically selecting range of data

ErikWetterberg — Sat, 08 Sep 2018 04:28:54 GMT

‌Hi Ian,

You could use selectValues and the numeric values for the dates. Or you could use search https://help.qlik.com/en-US/sense-developer/April2018/Subsystems/APIs/Content/BackendAPI/search-method.htm and an expression using <= and >=. If you decide to use search you will also need to call acceotSearch https://help.qlik.com/en-US/sense-developer/April2018/Subsystems/APIs/Content/BackendAPI/acceptsearch-method.htm.

Erik Wetterberg

https://extendingqlik.upper88.com/

Re: Programatically selecting range of data

Anonymous — Sat, 08 Sep 2018 18:14:50 GMT

Hey Erik thanks for your reply, it's much appreciated. I'm not at my computer at the moment but am I correct in thinking that I can use select values as so?

 app.field('exampleDate').selectValues([{qNum: "15/01/2018"},{qNum:"18/01/2018"},{qNum:"29/01/2018"}], true, true);

I am using JS

Re: Programatically selecting range of data

ErikWetterberg — Mon, 10 Sep 2018 06:39:04 GMT

Hi Ian,

No, thats a text format. The numeric format is a number, as described here:

Get the Dates Right

Erik Wetterberg

https://extendingqlik.upper88.com/

Re: Programatically selecting range of data

Anonymous — Mon, 10 Sep 2018 11:11:26 GMT

Thanks, man that worked a treat. I had to write a JS function to convert the date from "15/01/2018" format to the qlik / excel date format.

Gist to convert values here (requires moment and moment duration)