Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.0667 | 390,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
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]
, ',', '.')
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]
, ',', '.')
Under Number tab, check how the Decimal Separator has been defined. If it show comma, change it to dot
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
3. Make sure there are no surprises at front end - Measure formatting options