show '000s in chart caption

[#1]

Hi,

I have a chart with values in thousands and hundreds.

If i select a field with value 1000, then in chart header, i should show this '000s in chart header.

Since ' is a character used for text in qlikview, i am not able to use it in expression.

So how we can show '000s in chart header?

[Nicole-Smith · Accepted solution]

chr(39)&'000s'

[#3]

Thanks Nicole