Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

M² after a Value in a Dynamic Cross Table

Hi, I've a Dynamique Cross Table like that :

Name - Size - ...

A     -     25 - ...

B     -     26 - ...

C     -     27 - ...

How can i put a m² after my value in this table? In a simple table it's easy (Number -> format) but in this one ....

Thx in advice,

1 Solution

Accepted Solutions
Not applicable
Author

J'ai trouvé une solution pour l'arrondi :

ROUND([Size],0.01)&' m²'

View solution in original post

5 Replies
yduval75
Partner - Creator III
Partner - Creator III

added a calculted dimension in dimensions tab with :

[Size] & ' m ² '

Not applicable
Author

Okay c'es nikel et comment tu réduis la précision genre à 10²-2 maximum ? (ex : 115.689698 -> 115.69)

yduval75
Partner - Creator III
Partner - Creator III

Tu utilises la fonction Num()

Ex : Num([Size], '# ##0,00') & 'm ²'

Attention c'est un espace insecable donc copie colle le format souhaité dans l'onglet nombre.

yduval75
Partner - Creator III
Partner - Creator III

Si c'est ok peux tu valider ma réponse comme correcte ? Merci

Not applicable
Author

J'ai trouvé une solution pour l'arrondi :

ROUND([Size],0.01)&' m²'