Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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