Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

How do i format all Columns of my table?


i want to create a table Extension to format and edit tables.

Within I want to change the number format of all columns in my Table.

For example: Every number is formatted like this:"12,5","100,5",... and I want to change the format to "12,50","100,50",...

I don't want to change it column by column, I want to change every column at once (e.g. 12 columns to change).

How can i do this? Do you have any suggestions or tips for me?

Thank you very much for the answer!

1 Reply

Re: How do i format all Columns of my table?


this is maybe a bit late and a too simple answer, but you can change the format of an Expression in a table simply by deselecting numformat (Zahlenformat) automatically (Automatisch) into user defined.

Then hhange the format to number (Zahl) in the drop down menue and pick a format of your choice.

This won't change the format of a dimension in the table, but when you additionaly put the same field as an Expression (Kennzahl) next to the dimension into the table, then you can adjust the numformat of the Expression row for the output view (see Screenshot)


Community Browser