Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Round table

Hi,

maybe

LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;

SQL SELECT AMOUNTCURCREDIT


hope this helps


regards


Marco

5 Replies

Re: Round table

Hi,

maybe

LOAD ROUND(AMOUNTCURCREDIT,0.01) as CURCREDIT;

SQL SELECT AMOUNTCURCREDIT


hope this helps


regards


Marco

Re: Round table

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

- Marcus

Not applicable

Re: Round table

Hi Marco,

splendid. it works

Regards

Eric

Not applicable

Re: Round table

Hi Marcus,

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

Regards

Eric

Re: Round table

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

Community Browser