I am trying to load a .csv file to QliKView and I have managed to do that.
But I noticed that my numberformat was not right.
The output is at the moment : 1.000,00 etc
It needs to be 1000,00
There will be other datasources too, so I have not changed the thousand separator SET on the beginning from space to dot.
Is there a way to put there multiple thousandSep options?
Or does someone have a proper solution for this with the num() function? I tried, and failed.. it just brings the numbers before the thousandspearator to the view..
If there is the need to change the decimal-delimiter and/or the thousand-separator you will need the specify both parameters - only one parameter will be simply ignored. By using you output-format the following would work:
Thank you for your input. I tried your suggestion, but still it leaves the numbers over 1000 out from the field. So the numbers that have the format 1.000,00 or 1.000.000,000 .. These are on the left side if I take a look on the original field on the list box. So they are strings?
Are they displayed on the left side they will be interpreted as strings and you will need a solution like my example above with a num(num#()) expression to convert at first the value and then format it. For larger numbers you need to increase the number of # and/or you will need a switch within the num#() to detect the right conversion. I mean something like this:
