Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Round table

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

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe

LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;

SQL SELECT AMOUNTCURCREDIT


hope this helps


regards


Marco

View solution in original post

5 Replies
MarcoWedel

Hi,

maybe

LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;

SQL SELECT AMOUNTCURCREDIT


hope this helps


regards


Marco

marcus_sommer

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

- Marcus

Not applicable
Author

Hi Marco,

splendid. it works

Regards

Eric

Not applicable
Author

Hi Marcus,

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

Regards

Eric

MarcoWedel

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