topic Re: Conversion bigint in QlikView

Conversion bigint

Mon, 12 May 2014 11:49:34 GMT

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 ??

Re: Conversion bigint

jonathandienst — Mon, 12 May 2014 11:54:21 GMT

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

Re: Conversion bigint

alexandros17 — Mon, 12 May 2014 11:54:51 GMT

Load *;

Select

...

Where Convert(bigint,INSTAMOUNT) <>0;

Re: Conversion bigint

Mon, 12 May 2014 11:56:33 GMT

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