Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Mario3
Contributor
Contributor

Multiplying a field by 10 issue

Dear Qlikers, 

hope that you can help with this I am multiply a filed by 10 qlik is behaving like the below:

Expression : if(flag=1,[A DG1_Power_Active_P]*10,[A DG1_Power_Active_P]) as [A DG1_Power_Active_P2]

Output sample  :

 DG1_Power_Active_P DG1_Power_Active_P2
39.0667390,667

However DG1_Power_Active_P2   should provide the value of 390.667 not 390,667 How can I solve this issue.

Appreciate the help 

Thank you, 

Mario

1 Solution

Accepted Solutions
QFabian
MVP
MVP

Hi @Mario3 , one option is replace that character :

replace(

if(flag=1,[A DG1_Power_Active_P]*10,[A DG1_Power_Active_P]) as [A DG1_Power_Active_P2]

, ',', '.')

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

View solution in original post

3 Replies
QFabian
MVP
MVP

Hi @Mario3 , one option is replace that character :

replace(

if(flag=1,[A DG1_Power_Active_P]*10,[A DG1_Power_Active_P]) as [A DG1_Power_Active_P2]

, ',', '.')

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
Saravanan_Desingh

Under Number tab, check how the Decimal Separator has been defined. If it show comma, change it to dot

commQV91.PNG

PradeepK
Creator II
Creator II

1. Check field tags - it should be $numeric; if not use num(<field>) in load script

2. Check if decimal separator  is set to '.' in default variables 

default variables.PNG

 

3. Make sure there are no surprises at front end - Measure formatting options

number formatting.PNG