topic Re: New (Dec '23) pivot table number formatting in App Development

New (Dec '23) pivot table number formatting

N30fyte — Thu, 01 Feb 2024 11:23:34 GMT

I'm trying out the new Visualization Bundle pivot table and there is no Number Formatting drop-down for my measure:

I know I can format numbers in the expression but it's much more convenient with the drop-down, as you can with the 'old style' pivot:

Is this an accidental or deliberate omission? Or am I missing something?

Re: New (Dec '23) pivot table number formatting

jochem_zw — Fri, 02 Feb 2024 13:01:14 GMT

or even better first make master items for your measures and define the formatting in the master item. Than use the master items in your pivot and other objects.

Re: New (Dec '23) pivot table number formatting

N30fyte — Fri, 02 Feb 2024 14:49:14 GMT

Thanks but it's still not clear to me why there is no Number Formatting dropdown with the new pivot table, whereas there is with the old one and with other charts in the Visualization Bundle (eg Straight Table, Multi KPI...)

(It's also not clear to me why there is no text wrap in the column headers, or why it's not possible to download the new pivot table as an image or PDF, but again perhaps I'm missing something?)

Re: New (Dec '23) pivot table number formatting

NellyAcko — Fri, 02 Feb 2024 15:25:57 GMT

That is very strange May 2023 version has the standard number format drop down. Have you raised direct with support both internally and at QLIK

Re: New (Dec '23) pivot table number formatting

jochem_zw — Sat, 03 Feb 2024 20:14:35 GMT

New pivot is like you said new, so a first version but with a lot of improvements compared to old version, but there will probably a lot more updates to it in the future.

Re: New (Dec '23) pivot table number formatting

N30fyte — Mon, 05 Feb 2024 08:39:23 GMT

The new style pivot table I'm referring to was introduced into the Qlik Visualization Bundle (Custom Objects) in December 2023: Checkout the New Pivot Table! - Qlik Community - 2154705

Re: New (Dec '23) pivot table number formatting

T_Schmundt — Mon, 22 Apr 2024 10:13:51 GMT

I was also bothered by the fact that I couldn't format the measures in the new pivot table. A workaround would be to start with the old pivot table, format the values there as desired and then convert the table as a new pivot table. The number formats remain the same.

I hope that in further updates the number formatting feature will be added to the new pivot table.