Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jaipersr
Partner - Contributor II
Partner - Contributor II

Trouble displaying percent columns

Hi everyone I am trying to make a line graph in qlik sense which I think is a simple enough task. I have two columns, a dimension column and measure column,that I would like to display on the line graph. The measure column is a column of percents. To be clear this measure column is a calculated column.  I will show them below. My problem is that when I plot on a line graph the y axis has an "m" unit attached to it. It displays 1% as 10m, 2% as 20m and so forth. How do I get the line graph to display with the percent symbol correctly as opposed to this "m" format? Also what is the "m" format meant to denote?

 

Column DColumn M
Jan1%
Feb2%
Mar3%
Apr4%
May5%
4 Replies
lorenzoconforti
Specialist II
Specialist II

Strange; can you share a screenshot of of the number formatting section of that measure?

jaipersr
Partner - Contributor II
Partner - Contributor II
Author

If it means anything I am also trying to plot multiple measures on the same plot. I am toggling between measures using a dropdown filter. The actually data is shown below. The line graph correctly displays column M2 but when I toggle to M1 is when I get the issue. 

 

Column DColumn M1Column M2
Jan1%6
Feb2%7
Mar3%8
Apr4%9
May5%10
lorenzoconforti
Specialist II
Specialist II

Can you share the dashboard?

jaipersr
Partner - Contributor II
Partner - Contributor II
Author

Hi, 

I solved this problem. It seems as though I would call my measures inside of the pick function and that was the issue. For some reason the pick function ruins the format. As for why this does this I am at a loss. Any ideas?