Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cedfoning
Creator
Creator

bar chart

Hello, i have an issue : 

i have this bar chart : 

cedfoning_0-1647426507186.png

I want to have a dynamic title as follow : 
i have a filter [Position]. 

if no selection/all positions selected, then "all",

if several positions selected, then number of selected/total number,

if one position only, then the position name

 

@rwunderlich @Taoufiq_Zarra @sunny_talwar 

Labels (1)
2 Replies
anat
Master
Master

if(GetSelectedcount(field)=count({1} distinct field)or getselectedcount(field)=0,'All',getfieldselection(field))

brunobertels
Master
Master

hi may be somethink like this : 

if(getselectedcount(Position)=0,'ALL' ,

if(getselectedcount(Position)=1, GetCurrentSelections (),

if(getselectedcount(Position)>1, GetSelectedCount (Position) / (GetAlternativeCount ([Position) +GetSelectedCount (Position))

)))