Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Min & Max Dates GetFieldSelections for report

Hi all

I want to show the dates selected in a report but when I put the selections in the report it show 11 of 45 for months.

I have managed to create an expression which I can add to a text box and show the selections below :

=GetFieldSelections(Month, '; ', 100) & '   |   ' & GetFieldSelections(Division)

This shows all dates selected. and shows the Different Divisions

Apr 2015; May 2015; Jun 2015; Jul 2015; Aug 2015; Sep 2015; Oct 2015; Nov 2015; Dec 2015; Jan 2016; Feb 2016; Mar 2016; Apr 2016; May 2016; Jun 2016; Jul 2016; Aug 2016; Sep 2016; Oct 2016; Nov 2016; Dec 2016; Jan 2017; Feb 2017; Mar 2017; Apr 2017; May 2017; Jun 2017; Jul 2017; Aug 2017; Oct 2017   |   North Division

Is there a way I can adapt this so that it only shows Min date & max date so that I can show the following

Dates : Apr 15 to Oct 17

North Division

Many thanks

Phil

10 Replies
Anonymous
Not applicable
Author

All great.  Thanks All