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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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'))