Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Formatting as Numeric trouble

Hi all!

I am having an issue with forcing Qlikview to understand that Sales_Amt is numeric. The full numeric format of the document is #,##0.00. I tried to use evaluate() in conjuction with a multiplication with unity (1) to make it numeric and it worked fine with amount values that don't have the thousant separator as you can see in the following table excerpt.

Sales_Amt
Sales_Amt_Modiifed

=evaluate(Sales_Amt & '*1')
stringnumber
151.86 151.86
2,789.57 -
2,790.0 -
3,511.92 -
33.27 33.27
71.1 71.1
76.8 76.8
86.35 86.35

Do you have any ideas on how to approach the solution to this?

1 Solution

Accepted Solutions
Highlighted

Re: Formatting as Numeric trouble

Hi,

     Try this,

     Num#(Sales_Amt,'#,##0.00')

     Hope it helps

View solution in original post

4 Replies
Highlighted

Re: Formatting as Numeric trouble

Hi,

     Try this,

     Num#(Sales_Amt,'#,##0.00')

     Hope it helps

View solution in original post

Highlighted
Partner
Partner

Re: Formatting as Numeric trouble

hi,

Did you try  num(Fieldname,'#,##0')

Deepak

Highlighted
Not applicable

Re: Formatting as Numeric trouble

Hi Deepak!

Yes, I tried it before but at no success. Thanx for replying!

Highlighted
Not applicable

Re: Formatting as Numeric trouble

Yeap this worked!