Solved: Qlikview Escaping quotation mark (') - Qlik Community

Anonymous · ‎2017-06-14

Hi All

I want number should be displayed like this: 3'000 (not: 3,000) in an expression.

I have tried the following expressions, but not working:

=' Material: ' & num(COUNT(DISTINCT([MaterialCount])),'#,##0' , '.' , 'chr(39)')

=' Material: ' & num(COUNT(DISTINCT([MaterialCount])),'#&chr(39)&##0' , '.' , 'chr(39)')

Please help.

Thanks in Advance.

Anil_Babu_Samineni · ‎2017-06-14

Would you like to go this?

=' Material: ' & Replace(num(COUNT(DISTINCT [MaterialCount]),'#,##0'), Chr(44),Chr(39))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-06-14

Would you like to go this?

=' Material: ' & Replace(num(COUNT(DISTINCT [MaterialCount]),'#,##0'), Chr(44),Chr(39))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2017-06-14

Or this

=' Material: ' & Num(Count(DISTINCT([MaterialCount]), '#''###', '.', Chr(39))

marcus_malinow · ‎2017-06-14

Escape sequences