Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 :
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
Can you provide Sample App?
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 :
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.