Discussion Board for collaboration on QlikView Scripting.
I am just starting to use/learn qlikview/SQL.
This is a part of my code
ODBC CONNECT TO prdax2012_mirror (XUserId is xx, XPassword is yy); SQL SELECT ROUND(AMOUNTCURCREDIT,2) as CURCREDIT,
I would like to round my numbers in this table to 2 decimal digits. When I export the result in excel, some of the data has more than 2 decimals.
Any idea what I am doing wrong?
Go to Solution.
LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;
SQL SELECT AMOUNTCURCREDIT
hope this helps
In addition to the suggestion from Marco some background: Preceding Load.
splendid. it works
Thank you for the link, it helped me with understanding the logic of the answer of Marco.
glad it works.
please close your thread by marking an answer correct that solved your problem.
You can also mark answers helpful that delivered additional information.