dynamic bookmark and getfieldselections in chart subtitle

[Sarchiz]

Hi , 

So I have a dynamic bookmark set on current week:

{<week={"=week=Week(Today())"}>}

It works ok.

I need to put the current selected week or weeks in a chart subtitle.

This only works properly if you select weeks manually, otherwise it displays the expression used in the dynamic bookmark.

I am using getfieldselections in subtitle. 

Any ideas ?

[lironbaram]

hi 

just put the expression:Week(Today())

in your chart title

[Sarchiz]

Thanks , but it is not what I am looking for. 

I need the subtitle to show the selected week/weeks , regardless of what is active : the bookmark or user selection.

For when the bookmark is active it shows the expression not the actual week.

[lironbaram]

so use 

getfieldselections(Week) in your sub title

[Sarchiz]

here lies the problem, 

using : getfieldselections(Week)  when dynamic bookmark is active shows the expression not the actual week.

[lironbaram · Accepted solution]

so you can use something like 

=if(wildmatch(GetFieldSelections(week),'*Week(Today())*'),week(today()),GetFieldSelections(week))

[Sarchiz]

wow, it worked ! 

I guess I will research more about of this wildmatch  🙂

thanks a lot !

[arasaraja_cts]

May be you can use Concat(Week(Today()) , ',')