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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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²'