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: 
Anonymous
Not applicable

For Imput String

Hi,

i need help!, I read many forums and tried in many ways but I can't find a solution.

 

0683p000009MA24.png0683p000009M9bs.png0683p000009MA29.png

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

It seems you have the same character for both separators. Maybe my eyes, else change the 1rst one to "," and the 2nd to "."

View solution in original post

4 Replies
TRF
Champion II
Champion II

The input value contains a comma "," where a decimal point "." is expected (should be 10.78 instead of 10,78).

You should try to change the default settings for tFileInputExcel component.

Go to "Advanced settings" tab.

Tick the option "Advanced separator (for numbers)" the change the value for both fields "Thousands separator" and "Decimal separator" like this:0683p000009MA2E.png

Anonymous
Not applicable
Author

thanks for you reply, but i had already tried (and the error its the same)

also i changed the number to "." in excel and throws the same mistake.

 

sorry for mi english.

 

 

0683p000009M9xo.png

 

TRF
Champion II
Champion II

It seems you have the same character for both separators. Maybe my eyes, else change the 1rst one to "," and the 2nd to "."
Anonymous
Not applicable
Author

I had tried and it didn't work, but now yes, thank you very much!