topic Re: Date rannge picker Dashboard extension not working in Integration, Extension & APIs

Date range picker Dashboard extension not working

tamas_kiss — Sat, 16 Nov 2024 06:17:57 GMT

Hello,

I would like to ask you help with the Date Range Picker Dashboard Extension.

The extenension recognize my date field but nothing happens if I select a range or a date it does not filter the report, nothing happens.

The format of the field is MM/DD/YYYY, which is not the default in my region. Do I need to set up this seperately in the extension?

Thanks for your help in advance,

Re: Date rannge picker Dashboard extension not working

tamas_kiss — Tue, 26 Mar 2019 15:09:38 GMT

I have found the solution.

Just for others with same problem. The Date picker was not able to handle the format different from the default (despite it was defined in the code).

The solution was to create a second date field in the Master calendar in the default formar and set the Date Picker to use this field. Maybe it is nt the most elegant way but working.

Re: Date rannge picker Dashboard extension not working

brichnma — Tue, 25 Jun 2019 11:47:05 GMT

Hi,

I have the same problem you had and I don(t really understand your solution.

Can you please explain a bit more?

What do you mean by the default format?

My format of the date field is dd/mm/yyyy hh:mm:ss

And I have also an auto calendar that formats this date to dd/mm/yyyy

Many thanks

Re: Date range picker Dashboard extension not working

tamas_kiss — Tue, 25 Jun 2019 12:03:40 GMT

what is the default date format in the windows server?

For me, I had to use the Hungarian format YYYY. MM. DD

With this filed it is working for me.

Re: Date range picker Dashboard extension not working

brichnma — Tue, 25 Jun 2019 12:19:48 GMT

Thank you for your reply.

I have dd-MM-yy format in my windows server (see image). But I don't have in the options the format you have..

How can I use the right format in Qlik in this case please?

Regards,

Re: Date range picker Dashboard extension not working

tamas_kiss — Tue, 25 Jun 2019 12:28:19 GMT

For me this option does not worked.

I added a new date filed in my data model with the date function.

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Date.htm

Re: Date range picker Dashboard extension not working

brichnma — Tue, 25 Jun 2019 12:40:38 GMT

Thank you again for your help

I finally used date([Calendar.Date],'DD/MM/YYYY') since the extension uses this format.

And it works well.

Re: Date range picker Dashboard extension not working

SoftUser — Mon, 23 Mar 2020 07:41:37 GMT

Could you please clarify where did you made those changes ?

Re: Date range picker Dashboard extension not working

tamas_kiss — Mon, 23 Mar 2020 07:47:05 GMT

I have simply added a new filed to my master calendar in the data model where I have converted the date format with the DATE function

Re: Date range picker Dashboard extension not working

SoftUser — Mon, 23 Mar 2020 08:23:57 GMT

sorry to bother you...can you please attach a screenshot what you have done to the data model.