Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tamas_kiss
Contributor II
Contributor II

Date range picker Dashboard extension not working

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,

 

Labels (3)
1 Solution

Accepted Solutions
tamas_kiss
Contributor II
Contributor II
Author

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.

View solution in original post

9 Replies
tamas_kiss
Contributor II
Contributor II
Author

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.

brichnma
Contributor III
Contributor III

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

tamas_kiss
Contributor II
Contributor II
Author

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.

brichnma
Contributor III
Contributor III

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,

tamas_kiss
Contributor II
Contributor II
Author

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/Formatting...

brichnma
Contributor III
Contributor III

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.

 

SoftUser
Contributor II
Contributor II

Could you please clarify where did you made those changes ? 

tamas_kiss
Contributor II
Contributor II
Author

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

SoftUser
Contributor II
Contributor II

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