Discussion Board for collaboration on QlikView Layout & Visualizations.
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 ?
Go to 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,',')
it's working as expected !
thank's you very much
best regards !
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
Working when there is no selection (NS is dysplayed)
but if i select now sector1, NS s is still dysplayed
syntax error i suppose ...
i will do something like this
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 ?
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,','))
so easy !
thank's again :-))