topic Re: Trouble displaying percent columns in App Development

Trouble displaying percent columns

jaipersr — Mon, 20 Dec 2021 21:32:42 GMT

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 D	Column M
Jan	1%
Feb	2%
Mar	3%
Apr	4%
May	5%

Re: Trouble displaying percent columns

lorenzoconforti — Mon, 06 Apr 2020 17:17:23 GMT

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

Re: Trouble displaying percent columns

jaipersr — Mon, 06 Apr 2020 18:47:24 GMT

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 D	Column M1	Column M2
Jan	1%	6
Feb	2%	7
Mar	3%	8
Apr	4%	9
May	5%	10

Re: Trouble displaying percent columns

lorenzoconforti — Mon, 06 Apr 2020 19:06:28 GMT

Can you share the dashboard?

Re: Trouble displaying percent columns

jaipersr — Tue, 14 Apr 2020 13:22:47 GMT

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?