Rename row label in pivot chart

[Taylorcc]

Hello, 

I have a pivot table that counts clients living in the Brisbane region - how can I rename to first row to 'Outside of Brisbane catchment' 

Thank you 

[raji6763]

hi Taylorcc,

go to add  dimension and try this below expression

if(isnull([Mental health]),  'Outside of Brisbane catchment' , [Mental health]))

regards,

raji

[Vegar]

Hi @raji6763  suggestion is good, but you will need access to the Qlik Script. I you don't have access then you will need to create a calculated dimension whith this expression:

if(isnull([Mental health]),  'Outside of Brisbane catchment' , [Mental health]))

But this requires that you do have Null() values registred in the Mental health field (that you don't have missing values).

[Taylorcc]

Thank you - but they aren't nulls - just suburbs that are not within the Brisbane catchment...

[Kushal_Chawda]

Would you be able to share sample?

[raji6763 · Accepted solution]

hi ,

here is the solution:

=if( [Mental health]='Brisbane' ,  [Mental health] , 'Outside of Brisbane catchment' )

regards,

raji