Show selected dimension in Subtitle

[nina_jensen]

Hi

Is it possible to show the selected dimension in the subtitle of another table?

I would like to show the following in the subtitle for Selection as below;

If Date from-to is selected: From 1/1-16 to 3/1-16

If Week - Year is selected: Week 1-2016

If Month - Year is selected: Month Jan-2016

I managed to get one date or month by using

=if(CalDate,'Period' & ' ' & CalDate,'Period' & ' ' & MonthYear)

but as soon as I choose several dates it changes to MonthYear, and I am not able to set the expression for having Week-Year as a third option.

This is correct since only one date is selected.

This is correct - MonthYear is selected

Here it should say From 1/1/2016 to 4/1/2016

[paulfiney]

Hi Nina

Try this

"Date(Min(Date),'DD-MMM-YY') & ' to ' & Date(Max(Date),'DD-MMM-YY')"

This doesn't cater for the possiblity for excluding a date within the
Min-Max range, you could also look at using the function "GetFieldSelections ".

Regards

Paul

[shraddha_g]

Can you provide Sample App?

[brunobertels · Accepted solution]

Hi

Try this approach :

if(

getselectedcount(Mois)>0,

GetCurrentSelections(Mois),

if(

getselectedcount(Semaine)>0,

GetCurrentSelections(Semaine),

if(

getselectedcount([date du Rdv])>0,

'From ' &min([date du Rdv]) &' to ' & max([date du Rdv])

)))

I got a model with those filter panel :

and a KPI object like that :

so if a select a Month ( Mois) :

if a select a week ( Semaine) :

and if a select date :

[nina_jensen]

Hi all,

Thank you for your feedbacks on my question.

Unfortunately I did not have the opportunity to check this out during the weekend, but I will get in to it shortly and give you a feedback on the result.