Discussion board where members can get started with QlikView.
Hi, I am loading a table from Excel and I want to round a column of numbers. The excel version works just fine, but how do I write it in the Load statement. Here is the excel version:
So 28.7 would be 29 and 28.6 would be 28.
So what I have now is not working for me:
if((Amount-TRUNCATE(Amount,0)>=Roundup(Amount,0),Rounddown(Amount,0)) as Amount
I can't find the appropriate syntax for this. If anyone could point me in the right direction. Thanks!
Go to Solution.
Translated into qlik syntax:
IF(Frac(Amount)>=0.7,ceil(Amount),floor(Amount)) as Amount
View solution in original post