topic Chart Title Expression in Water Cooler

Chart Title Expression

zwyne — Fri, 11 Jan 2019 09:27:58 GMT

Hi All,

PFA,

Please assist with my expression for the chart title,

=if(GetCurrentSelections(Country)=0 and GetCurrentSelections(BU)=0,'Evidence CA','Evidence CA'&'('&GetFieldSelections(BU)&')') .

So for example when I select BU='CIB' , the chart title is displayed as Evidence CA(CIB), but when I select for Country ='Kenya', the chart displays Evidence CA(). How can write the expression which will cater for either Country or BU?

Thanks

Re: Chart Title Expression

agigliotti — Fri, 11 Jan 2019 10:17:35 GMT

what does your expected result for Country = Kenya is ?

Re: Chart Title Expression

zwyne — Fri, 11 Jan 2019 11:18:56 GMT

So I expect when I select Country ='Kenya' in the listbox for example and my chart title displays Evidence CA(Kenya) and similarly if I select BU='CIB' in the listbox then my chart title displays Evidence CA (CIB). Same thing for the IR Charts

Re: Chart Title Expression

agigliotti — Fri, 11 Jan 2019 11:37:12 GMT

maybe this:
='Evidence CA' & '('&GetFieldSelections(Country)&GetFieldSelections(BU)&')'

Re: Chart Title Expression

sunny_talwar — Fri, 11 Jan 2019 12:31:15 GMT

Try this

=If(GetSelectedCount(Country) = 0,
	If(GetSelectedCount(BU) = 0, 'Evidence CA', 'Evidence CA('& GetFieldSelections(BU) &')'),
	If(GetSelectedCount(BU) = 0, 'Evidence CA('& GetFieldSelections(Country) &')'))

Re: Chart Title Expression

zwyne — Fri, 11 Jan 2019 13:46:36 GMT

Thank you very much Sunny, always a life saver