DYNAMIC TITLE WITH SEVERAL VALUES

[philgood34]

Hi

i have a graph with dynamic title (graph) linked to the field NCL_LIB (including values : sector 1, sector2 ...) as shown

My issue, is then i select several values, the title disappear ...

I used this variable

in this expression

A idea ?

REGARDS

Philippe

[lironbaram · Accepted solution]

if there is more than one value

than your expression will result in null

if you want to display all selected values

you can use this expression in your variables:  =concat(NCL_LIB,',')

[philgood34]

it's working as expected !

thank's you very much

best regards !

[philgood34]

Another question Liron please ,

if i want to inclue a condition in the expression, what is the syntax ?

for example : "if there is no sectors selected, the title have to be "NS"

i try this

=if('$(NCL_LIB)'='','NS','$(vSECTEURS)')

Working when there is no selection (NS is dysplayed)

but if i select now sector1, NS s is still dysplayed

syntax error i suppose ...

regards

Philippe

[lironbaram]

Hi

i will do something like this

=if(getselectedcount(NCL_LIB)=0,'NS', concat(NCL_LIB,','))

[philgood34]

perfect !

best regards

Philippe

[philgood34]

Hi Liron

I have a additional question for you !

i completed my issue with multiple conditions; let me explain :

i applied your expression to 2 fields  FILIERES/SECTORS, and not only SECTORS

llike this :

=if(getselectedcount(NCL_LIB)=0,if(getselectedcount(FILIERES)=0, 'EMPTY',concat(FILIERES,',')), concat(NCL_LIB,','))

it's working pretty good in 2 cases out of 3 :

    

here is the issue : repetitive filieres's value in the title, when i selected one "FILIERES" (PF, PF, PF instead of only PF) 

have you a idea to fix it  ?

regards

Philippe

[lironbaram]

hi

apparently this field has the same value in several different rows

so this is the reason for the duplicate

it's an easy fix

=if(getselectedcount(NCL_LIB)=0,if(getselectedcount(FILIERES)=0, 'EMPTY',concat(distinct FILIERES,',')), concat(distinct NCL_LIB,','))

[philgood34]

so easy !

thank's again :-))

regards

Philippe