topic Re: Title in QlikView

Title

kevbrown — Thu, 12 May 2016 11:11:29 GMT

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

Re: Title

Thu, 12 May 2016 11:20:08 GMT

Could you provide your same application.

-Uva

Re: Title

Kushal_Chawda — Thu, 12 May 2016 11:25:33 GMT

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

Re: Title

kevbrown — Thu, 12 May 2016 12:02:06 GMT

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

Re: Title

Kushal_Chawda — Thu, 12 May 2016 12:06:22 GMT

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

Re: Title

tresB — Thu, 12 May 2016 12:09:13 GMT

May be this:

='Score '& GetCurrentField(DrillGroupName)

Re: Title

Anonymous — Thu, 12 May 2016 12:11:01 GMT

'score' &score unit

Re: Title

kkkumar82 — Thu, 12 May 2016 12:15:47 GMT

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

Re: Title

kevbrown — Thu, 12 May 2016 12:17:17 GMT

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

Re: Title

Anonymous — Thu, 12 May 2016 12:18:42 GMT

get selection field(field name)

Re: Title

kkkumar82 — Thu, 12 May 2016 12:20:03 GMT

Then u have to mix mine and kushals code

Re: Title

kevbrown — Thu, 12 May 2016 12:20:04 GMT

That only pulls down the field name, not the value

Re: Title

tresB — Thu, 12 May 2016 12:20:18 GMT

Try like:

='Score '& GetCurrentField(DrillGroupName) &': ' & $(=GetCurrentField(DrillGroupName))

Re: Title

kkkumar82 — Thu, 12 May 2016 12:21:53 GMT

'Score '& if( getselectedcount(Zone)>0, Concat(distinct Zone,',') & ' ' &subfield(GetCurrentSelections(),':',1),'')

Try this for Zone