Conversion bigint

[#1]

Hello all,

     i have sql query like Convert(bigint,INSTAMOUNT) <>0 where INSTAMOUNT is 112332.00,4564.00 etc,how can i implement this in qlikview ??

[jonathandienst]

Hi

QV should require no special handling for that number, as long as there are 15 digits or less. (or is it 14?). If they have more digits, QV will load the number as a float (in exponential format), which will result in some loss of precision.

HTH

Jonathan

[alexandros17]

Load *;

Select

...

Where Convert(bigint,INSTAMOUNT) <>0;

[#4]

Is this part of SQL in your where-clause?

In that case, you can just copy/paste your query into the QV-loadscript like this

load *
//the part above is Qlikview-logic / syntax
;
//the part below goes to your database (so database logic / syntax)
sql select * FROM [yourtablename] where 
convert(bigint,INSTAMOUNT) <>0;

If the filtering needs to be done in Qlikview, then I would make sure that the column is integer/numeric and just filter on columname <>0