Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?!
Make sure, Date picker holding the same dimension because some fields will generate by Qlik which is not associate with normal dimensions.
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.