topic Re: chart title issue in QlikView

chart title issue

manoranjan_d — Fri, 26 Aug 2016 10:29:58 GMT

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' )

Re: chart title issue

maxgro — Fri, 26 Aug 2016 10:38:25 GMT

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

Re: chart title issue

Anil_Babu_Samineni — Fri, 26 Aug 2016 10:38:39 GMT

Did you put:

= dept

on your title?

Hope it helps,

OR post your example

Re: chart title issue

Anonymous — Fri, 26 Aug 2016 10:41:13 GMT

try this

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

'Total Incoming amount' )

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

'Total Incoming amount' )

Re: chart title issue

avinashelite — Fri, 26 Aug 2016 10:44:20 GMT

Try like this

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

Re: chart title issue

manoranjan_d — Fri, 26 Aug 2016 10:45:53 GMT

Hi Grossi

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

Re: chart title issue

avinashelite — Fri, 26 Aug 2016 10:48:04 GMT

Did you tried this

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

Re: chart title issue

trdandamudi — Fri, 26 Aug 2016 11:01:11 GMT

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 ?

Re: chart title issue

Anonymous — Fri, 26 Aug 2016 11:02:49 GMT

Did you try my solution ?

Re: chart title issue

manoranjan_d — Fri, 26 Aug 2016 11:28:52 GMT

thanks

Re: chart title issue

Anonymous — Fri, 26 Aug 2016 11:33:29 GMT

if(GetFieldSelections(ID)>0,Concat(ID)&Chr(13))