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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
bonaiti
Contributor II
Contributor II

variable comma problem sum

Hi,

I have a problem with a variable with comma. I sum a field with the variable, but decimal not sum

See the image in the exemple!

HELP!error loading image

Robert

2 Replies
Not applicable

hi,

probabaly in the number tab u should set number as number format settings and give the format pattern #,##0.00. and use . as a separator for decimal and , as a separator for thousand

thanks

bonaiti
Contributor II
Contributor II
Author

I solve.

SUM([Costo FDL]) + num('$(MP)', '#.##0,00')

Cool