topic Re: Reference lines numbers formatting in App Development

Reference lines numbers formatting

tomzof74 — Tue, 16 May 2017 00:04:14 GMT

Hi,

After upgrading to the recent version numbers aside the reference lines ceased to accept axis' number formatting.

I doubt if that's intentional. Anyone else is experiencing this?

Thanks,

Tomasz

Re: Reference lines numbers formatting

Tue, 08 Aug 2017 17:27:44 GMT

Me and my team also began to experience this issue, are there any workarounds known?

My reference line numbers are not being auto-formatted with the numbers, so we're getting large numbers like 286,000,000 in the reference line where they used to be auto-formatted to 286.0M

Re: Reference lines numbers formatting

Ivan_Bozov — Tue, 08 Aug 2017 17:54:45 GMT

Hi! You can force Qlik Sense to show it in the desired format, e.g. the following will format the result as percentage:

Num((Sum(Value_1)/Sum(Value_2)),'#,##%')

Re: Reference lines numbers formatting

Tue, 08 Aug 2017 18:10:53 GMT

Thanks Ivan, this helped. But to get it to work I had to implement the num function in both the measure and the reference line.

I wonder why the auto-format stopped working with the update to 3.2 SR3? My company cannot quickly go to the June release for stability reasons.

Re: Reference lines numbers formatting

Ivan_Bozov — Tue, 08 Aug 2017 18:23:22 GMT

Probably a bug, it also didn't work for me with 3.2 but works just fine with June 2017.

Re: Reference lines numbers formatting

nicholas5141 — Wed, 09 Aug 2017 01:41:55 GMT

References line format follow measure formatting.

It works for me.

Re: Reference lines numbers formatting

Ivan_Bozov — Wed, 09 Aug 2017 06:17:03 GMT

In QS Desktop 3.2 SR3 for sure it doesn't.

Re: Reference lines numbers formatting

nicholas5141 — Wed, 09 Aug 2017 06:44:37 GMT

Hi I tested it works. Both references line are using AVG. Please change the format in measure.

Re: Reference lines numbers formatting

Ivan_Bozov — Wed, 09 Aug 2017 07:00:40 GMT

Try doing the same when the original number is percentage with 10 decimal places and you want it to show only 2.

Moreover, you are using June 2017 which, as I said before, works just fine. The issue is with 3.2. SR3

Re: Reference lines numbers formatting

nicholas5141 — Wed, 09 Aug 2017 07:08:38 GMT

Hi, Can as per screenshot.

Re: Reference lines numbers formatting

Ivan_Bozov — Wed, 09 Aug 2017 07:10:50 GMT

Is this still the June 2017 version?

Re: Reference lines numbers formatting

nicholas5141 — Wed, 09 Aug 2017 07:17:18 GMT

Yes from the screenshot is June 2017.

I tested 3.2 Enterprise work.

Re: Reference lines numbers formatting

Ivan_Bozov — Wed, 09 Aug 2017 07:23:18 GMT

As I already said, this doesn't work in QS Desktop 3.2 SR3 and is fixed in June 2017. I have no idea about 3.2 Enterprise.

In QS Desktop 3.2 SR3 for sure it doesn't.

Moreover, you are using June 2017 which, as I said before, works just fine.