topic Re: Round table in QlikView

Round table

Fri, 26 Feb 2016 14:52:01 GMT

Hi,

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?

Regards

Eric

MarcoWedel — Sat, 27 Feb 2016 03:20:43 GMT

Hi,

maybe

LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;

SQL SELECT AMOUNTCURCREDIT

hope this helps

regards

Marco

marcus_sommer — Sat, 27 Feb 2016 19:11:04 GMT

In addition to the suggestion from Marco some background: Preceding Load.

- Marcus

Mon, 29 Feb 2016 07:17:39 GMT

Hi Marco,

splendid. it works

Regards

Eric

Mon, 29 Feb 2016 07:18:55 GMT

Hi Marcus,

Thank you for the link, it helped me with understanding the logic of the answer of Marco.

Regards

Eric

MarcoWedel — Mon, 29 Feb 2016 22:09:32 GMT

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.

thanks

regards

Marco