Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current Selection Display of Dates selected from Slider

I have a calendar represented via slider. When a date range is selected from the slider, the default Current Selection Display is xxx of xxxx. Is there a way to format the selection to display the appropriate date range selected ie. Mar 21, 2010 to Mar 30, 2010 ? I was thinking of using a text box to properly set the display - GetFieldSelections([date here]) and including a min/max but unable to get the desired output. Any idea is appreciated.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You should be able to display in a text object with the expression:

=min(DateField) & ' to ' & max(DateField)

-Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You should be able to display in a text object with the expression:

=min(DateField) & ' to ' & max(DateField)

-Rob

Not applicable
Author

Thanks for the tip. I have revised the expression to check for nulls, add a column description and format the dates accordingly.

=if(Isnull(GetFieldSelections([DateField)])),'','Delivery Date : '&Date(min([DateField]),'YYYY-MM-DD') &' to '&
Date(max([DateField]),'YYYY-MM-DD'))