chart title issue

[manoranjan_d]

Hi my chart title is not picking as per the selection in the list box

below is the expression i used

=if(GetFieldSelections(dept),'Total Incoming amount For ' & dept, 'Total Incoming amount' )

[maxgro]

=if(Len(GetFieldSelections(dept)),'Total Incoming amount For ' & concat(distinct dept, ','), 'Total Incoming amount' )

[Anil_Babu_Samineni]

Did you put:

= dept

on your title?

Hope it helps,

OR post your example

[Anonymous]

Hi

try this

=if(GetFieldSelections(dept),'Total Incoming amount For : $(=Concat(Distinct dept,' ,')',

          'Total Incoming amount' )

Or

=if(Aggr(sum(1),dept)>0,'Total Incoming amount For : $(=Concat(Distinct dept,' ,')',

          'Total Incoming amount' )

[avinashelite · Accepted solution]

Try like this

=if(Len(Getselectedcount(dept))>0,'Total Incoming amount For ' & GetFieldSelections(dept,','), 'Total Incoming amount' )

[manoranjan_d]

Hi Grossi

your expression is working fine but if i make multiple selections then its not working, how to do that

[avinashelite]

Did you tried this

=if(Len(Getselectedcount(dept))>0,'Total Incoming amount For ' & GetFieldSelections(dept,','), 'Total Incoming amount' )

[trdandamudi]

Are you sure.. Massimo solution is working and if you select multiple then it is showing the multiple selections. When you are selecting multiple what is your output ?

[Anonymous]

Hi

Did you try my solution ?

[manoranjan_d]

thanks