Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
Strange; can you share a screenshot of of the number formatting section of that measure?
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 |
Can you share the dashboard?
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?