topic Re: Qlikview Escaping quotation mark (') in QlikView

Qlikview Escaping quotation mark (')

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 14 Jun 2017 07:11:13 GMT

Would you like to go this?

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

sunny_talwar — Wed, 14 Jun 2017 07:24:13 GMT

Or this

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

marcus_malinow — Wed, 14 Jun 2017 09:01:30 GMT