Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
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
Load *;
Select
...
Where Convert(bigint,INSTAMOUNT) <>0;
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