I have a excel sheet with a number format in a column as following '00.000.000/0000-00'.
How can I format this into 00000000000000 in Qlikview?
I am using this field to associate with another table.
I look forward to your help.
Use the PurgeChar() function along with the Num() function:
Num(PurgeChar('00.000.000/0000-00', './-')) AS Number
The second parameter in PurgeChar() may be any other non numeric character.
Hope that helps.
Try with this
Text(KeepChar(FieldName,'0123456789')) as NumberField
Text(PurgeChar(FieldName,'./-')) as NumberField
Thanks for the prompt reply. That was of a good help.
hope this helps
Retrieving data ...