topic Re: Select date using selectValues api in Integration, Extension & APIs

Select date using selectValues api

boonhaw_tan — Mon, 11 Apr 2016 12:52:51 GMT

Hi All,

I have a multiple html pages mashup but i having problem to preserve current selection between html pages.

Thus, i tried to using browser sessionstorage method to store current selection made in page A then retrieve the selection from sessionstorage in page B and using selectValues api to perform pre-select.

I able to selectValues() for interger and text but i having problem to use selectValues for selecting date.

Kindly advice how can select date using selectValues.

app.field('customer_name').selectValues(["Peter"], true, true) -> working

app.field('year').selectValues([2014], true, true) -> working

app.field('date').selectValues(['1/7/2013'], true, true) -> not working

Thanks.

Re: Select date using selectValues api

boonhaw_tan — Mon, 11 Apr 2016 16:03:29 GMT

Hi akl‌ would need your help on selectValues for date.

Re: Select date using selectValues api

tseebach — Thu, 05 Jan 2017 15:09:21 GMT

You need to make sure you use the same format as in your app. And remember the display format can be different than the data format on the field level. So look into your datamodel what format your using, and use the same.

Otherwise use the date as a number when it passed. And make sure that the date field has no timestamp in it.

If you want to be sure then format your date like: date(floor(datefield),"d/m/yyyy") as date then your code should work.

Re: Select date using selectValues api

Aiham_Azmeh — Sun, 08 Jan 2017 17:30:19 GMT

Hi boonhaw.tan,

seebach‌ is right, It looks like your field "date" has a numeric value, so you will probably have to pass an object with qIsNumeric: true and qNumber: _value_number_ (SelectValues method ‒ Qlik Sense)

But what I recommend you to use in that specific case is selectMatch instead (selectMatch method ‒ Qlik Sense), this method will automatically try to match the date.

Regarding keeping current selections between mashup pages, you can find a good thread here: Re: Keep current selection between mashup page

I hope this helps,

Re: Select date using selectValues api

jasonmomoa — Tue, 23 Jan 2018 09:38:57 GMT

Hi boonhaw.tan,

Field API selectValues() method allows either string or numeric values in the array. However, for dates you must use the numeric value of the given date. Check how Qlik converts date values in the documentation here.

Then, the equivalent call of

app.field('date').selectMatch('01/07/2013');

would be

app.field('date').selectValues([41281]);

in 'MM/DD/YYYY' format. You can check the numeric value using the Num(Date(my_date)) Qlik's function.

All you gotta do now is re-create the same conversion from Qlik to your Mashup qlikDateStringToNum().

Hope that helps 🙂

Regards,

Re: Select date using selectValues api

jasonmomoa — Tue, 13 Feb 2018 09:44:50 GMT

Hi boonhaw.tan‌, did this solve the issue?

Re: Select date using selectValues api

dipankarm — Sat, 04 May 2019 15:06:42 GMT

Hi @Aiham_Azmeh ,

Is there a problem in using selectValues() for Alphanumeric values?

selectValues() seems to be working only for string values for me and not for Numerical ones.

Can you please provide some code snippet as in how the syntax would be for Alphanumeric/Numeric values?

Would be really appreciated. Thanks in advance!

Re: Select date using selectValues api

amit_ghaste — Wed, 28 Aug 2019 19:16:21 GMT

selectValues will work as long as you convert numeric values to a number array

I haven't solved for date though.

$.each(selection.qSelectedFieldSelectionInfo, function(key,value){ isNaN(value.qName) ? valArray.push(value.qName):valArray.push(Number(value.qName)); }); promiseArray.push(fld.selectValues( valArray, true, true ));

Re: Select date using selectValues api

Prashant_Naik — Mon, 02 Sep 2019 10:08:18 GMT

Hello Amit,

I think this might help you,

you can try using following code

app.field('fieldname').selectMatch(match string);

app.field('fieldname').selectPossible();

Thanks & Regards,

Prashant

Re: Select date using selectValues api

amit_ghaste — Tue, 03 Sep 2019 14:22:30 GMT

Prashant,

What does selectPossible after calling selectMatch accomplish?

Though if there are multiple values we have to recurse through the selections to perform selectMatch -> I am hoping to find a way around that.

Thanks,

Amit.

Re: Select date using selectValues api

MichelW — Wed, 16 Sep 2020 06:35:19 GMT

Hi There,

sorry that i revive this thread, but i have a question regarding the selectValue() situation with the number (qNum) of date entrys within a field.

I am trying to select a range of values starting from 30 days ago from today.

That is all not a problem but, my field has entrys with timestamps which resolves as a xxxxx.xxxxxxxxxx pattern in the qNum part of the field.

Now the actual question is, how do i select entrys if i dont know the part after the "."

but just know the part in front of it?

what i was trying to do was like this:

app.field("someDateField").selectValues([array[0],......,array[29]]);

to select the entrys with the past 30 days. Well as you might expect, it didnt work out.

Since there are more then just 30 entrys infact it might be more then 30 entrys per day.

Is there any soloution to this problem? Like a selectRange variant or wildcard selection?

Kind Regards

Re: Select date using selectValues api

kishore3k — Thu, 07 Jan 2021 11:40:33 GMT

Hi Jason,

Hope you are well!

The link( here ) you have provided seem to be broken . Could you please provide the same again?

I have same issue where I couldn't select the date format fields using SelectValues API. Please check this thread- https://community.qlik.com/t5/Qlik-Sense-Integration-Extensions-APIs/Issue-in-SelectValues-Field-API-when-the-field-is-Date-format/td-p/1772241

Re: Select date using selectValues api

addhyperlinkstopivottablenow — Mon, 02 May 2022 09:40:47 GMT

This should be added to the API docs!