Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sharmasapna
Contributor III
Contributor III

Qlikview Escaping quotation mark (')

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.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Would you like to go this?

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Anil_Babu_Samineni

Would you like to go this?

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Or this

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

marcus_malinow
Specialist III
Specialist III