Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've come across a strange issue with the labelling in a continuous area chart. The x-axis shows a day of year number, the y-axis shows a % change value. However, if a user chooses to select a range of days, the day numbers are shown as a %, as if it's picking up the number formatting from the y-axis expression:
This does not happen if a user hovers over a data point in the chart, it shows the day number correctly:
Additionally, in a similar continuous line chart, which has an integer value for the y-axis, this is not observed, and the day number is shown as expected:
We're using Qlik Sense November 2025 patch 2.
Has anyone come across this before, or have an idea how to fix it? I've tried wrapping the day number field in a Num() formatting function, but it still comes out as a %.
Many thanks,
Azam
Hi, it would be nice if you could upload a dummy app that demonstrates the behaviour, so we could test in out environments and look if there is a solution.
Hi,
Dummy app attached as requested.
Thanks,
Azam
Hi, I did some test and it always shows using the number format of the Y axis.
I tried creating a master item, using Num() in expression with different number formats, setting the format on script.
The closest solution was to change the % format to numeric with 2 decimals (without percentage), and multiply the expression by 100.
Another option could be to add a dummy measure with Null() as expression and integer as format, but this way also changes the format of the Y axis, so the result is the same but with an extra measure, so more messier that the previous workaround.
Not the result we wanted. I upload them just in case it gives you another idea that works better.
Hi,
Thanks for taking the time to look at this. Both your suggestions have merit, but I think it does point to this being a bit of a bug, so I'll raise it with Qlik. In the meantime, I have reverted to using a non-continuous y-axis with scrolling.
Many thanks,
Azam
I agree, the format of the Y-axis measure should not set the format of the X-axis filters.