Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
kristen_qlik_noob
Contributor III
Contributor III

Changing Measure Value Labels in a Bar Chart

I have a bar chart where I am showing the percentage of the total: Count(Q2701)/Count(TOTAL Q2701)

The issue I am having is the Variable has numbers in the column but I would like it to display company names instead of the numbers. 

So on the x axis instead of showing 1, 2, 3, 4. I would like 1 = Auto Company, 2 = Insurance Company etc etc...

What is the best way to do this? 

1 Solution

Accepted Solutions
Channa
Specialist III
Specialist III

create calculated dimension

IF(Variable=1,'Auto Company',IF(variable=2,'Insurance Company'))

try

Channa

View solution in original post

5 Replies
dplr-rn
Partner - Master III
Partner - Master III

What is your dimension here? is it a column in the datamodel?
kristen_qlik_noob
Contributor III
Contributor III
Author

I am using the same variable for Dimension and Measure. Q2701. I am just wanting a breakdown of the %'s of 1, 2, 3, 4 response on the bar chart which I have. I just want the names to change on the chart from 1, 2, 3, 4 to Company names on the chart.
dplr-rn
Partner - Master III
Partner - Master III

Not clear what you mean. please share a sample if you can.
Channa
Specialist III
Specialist III

create calculated dimension

IF(Variable=1,'Auto Company',IF(variable=2,'Insurance Company'))

try

Channa
kristen_qlik_noob
Contributor III
Contributor III
Author

Worked, thanks