Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
nina_jensen
Not applicable

Show selected dimension in Subtitle

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.

Date.jpg

This is correct - MonthYear is selected

Month.jpg

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

Month1.jpg

1 Solution

Accepted Solutions
brunobertels
Not applicable

Re: Show selected dimension in Subtitle

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 :

4 Replies
paulfiney
Not applicable

Re: Show selected dimension in Subtitle

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
Not applicable

Re: Show selected dimension in Subtitle

Can you provide Sample App?

brunobertels
Not applicable

Re: Show selected dimension in Subtitle

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
Not applicable

Re: Show selected dimension in Subtitle

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.