topic Re: DYNAMIC TITLE WITH SEVERAL VALUES in QlikView

DYNAMIC TITLE WITH SEVERAL VALUES

philgood34 — Mon, 04 Sep 2017 14:15:48 GMT

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

Re: DYNAMIC TITLE WITH SEVERAL VALUES

lironbaram — Mon, 04 Sep 2017 14:21:24 GMT

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

Re: DYNAMIC TITLE WITH SEVERAL VALUES

philgood34 — Mon, 04 Sep 2017 14:24:02 GMT

it's working as expected !

thank's you very much

best regards !

Re: DYNAMIC TITLE WITH SEVERAL VALUES

philgood34 — Mon, 04 Sep 2017 14:56:00 GMT

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

Re: DYNAMIC TITLE WITH SEVERAL VALUES

lironbaram — Mon, 04 Sep 2017 16:01:52 GMT

i will do something like this

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

Re: DYNAMIC TITLE WITH SEVERAL VALUES

philgood34 — Mon, 04 Sep 2017 16:06:39 GMT

perfect !

best regards

Philippe

Re: DYNAMIC TITLE WITH SEVERAL VALUES

philgood34 — Tue, 05 Sep 2017 06:26:38 GMT

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

Re: DYNAMIC TITLE WITH SEVERAL VALUES

lironbaram — Tue, 05 Sep 2017 06:36:21 GMT

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

Re: DYNAMIC TITLE WITH SEVERAL VALUES

philgood34 — Tue, 05 Sep 2017 06:41:40 GMT

so easy !

thank's again :-))

regards

Philippe