Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to concat expression and string

hi , am new to qlick view .

and i have one expression

=num(sum(DISTINCT RNUNTS_SQFT_AREA)/Area_Divide,'#.###')

and i want to add string 'sqft' at chartchart.PNG

i want to display like 0.02 sqft,0.35 sqft,0.71sqft .

thank in advance

1 Solution

Accepted Solutions
Not applicable
Author

am changed in number tab ,number format like ###########,### sqft

its working

thank  a lot

View solution in original post

7 Replies
marcus_sommer

Try: =num(sum(DISTINCT RNUNTS_SQFT_AREA)/Area_Divide,'#.### sqft')

- Marcus

santhoo_san
Partner - Creator II
Partner - Creator II

=num(sum(DISTINCT RNUNTS_SQFT_AREA)/Area_Divide,'#.### sqft')

Not applicable
Author

AM tried  that one already but not showing that particular  formate

sunny_talwar

You might need to change the number format to Default Expression on the Number tab of the chart properties. Have you done that already?

marcus_sommer

Have you enabled within the tab numbers the number-format: expression?

- Marcus

Not applicable
Author

i done already

Not applicable
Author

am changed in number tab ,number format like ###########,### sqft

its working

thank  a lot