Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ruthie09
Contributor III
Contributor III
‎2019-08-30 11:48 AM

How to use ConvertToLocalTime with Date Range Picker

Please help!

I cannot figure out how to get a date range picker to work with the ConvertToLocalTime option.

This is the formula I currently have in my dimension:

=date(ConvertToLocalTime([inc_sys_created_on.autoCalendar.Date], '$(SelectedTimeZone)'))

While this formula works great in a standard filter (whether picking one date or multiple dates), when I select one or more dates in the date picker, nothing happens.

HELP?!

Labels (3)
545 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2019-08-30 10:55 PM

Make sure, Date picker holding the same dimension because some fields will generate by Qlik which is not associate with normal dimensions.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
516 Views
0 Likes
Ruthie09
Contributor III
Contributor III
‎2019-09-03 09:16 AM
Author

In response to Anil_Babu_Samineni

I'm sorry, I don't understand your answer.  The date dimension I used is one of the auto-generated date fields produced by click.  The original field, pulled in from source data, is inc_sys_created_on.  Using that field, instead of the Qlik-generated version made no difference.

476 Views
0 Likes