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: 
kevbrown
Creator II
Creator II

Title

I want to name my chart whatever the current selection is but only to the last selection made. So, I have Zone, Unit, Product. I was my initial title to say "Score", then once I've selected Zone, I want it to say "Score Zone" (whatever the zone is they've selected), once a unit is selected it needs to read "Score Unit", therefore ignoring the Zone.  Ideas?

Kev

13 Replies
Not applicable

Could you provide your same application.

-Uva

Kushal_Chawda

='Score '& if( getselectedcount(Zone)>0, Zone,'')

kevbrown
Creator II
Creator II
Author

That just returns the Zone, I want it to change to say the unit once I've drilled into Unit

Kushal_Chawda

'Score '& if( getselectedcount(Zone)>0, Concat(distinct Zone,','),'') & if( getselectedcount(Unit)>0, Concat(distinct Unit,','),'')  & if( getselectedcount(Product)>0, Concat(distinct Product,','),'')

tresesco
MVP
MVP

May be this:

='Score '& GetCurrentField(DrillGroupName)

Anonymous
Not applicable

'score' &score unit

kkkumar82
Specialist III
Specialist III

May be this , if u don't want the values of the field, only field name

Score '& if(GetSelectedCount(Zone)>0, subfield(GetCurrentSelections(),':',1),'')


..

..

similar to others

kevbrown
Creator II
Creator II
Author

I want the value too, so once I selected Zone A I want the title to say Zone A, then if I selected Unit 3, I want it to say just Unit 3, not Zone A

Anonymous
Not applicable

get selection field(field name)