Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?