Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Rename row label in pivot chart

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' 

 

Taylorcc_1-1592190686708.png

 

Thank you 

Labels (4)
1 Solution

Accepted Solutions
raji6763
Creator II
Creator II

hi ,

here is the solution:

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

 

regards,

raji

View solution in original post

5 Replies
raji6763
Creator II
Creator II

hi Taylorcc,

go to add  dimension and try this below expression

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

 

regards,

raji

Vegar
MVP
MVP

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
Contributor III
Contributor III
Author

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

hi ,

here is the solution:

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

 

regards,

raji