topic Re: Qlikview reads data incorrectly from sql in QlikView

Qlikview reads data incorrectly from sql

mayuranp — Sat, 30 Mar 2019 00:40:20 GMT

I have a SQL Server view for customer. One customer has CustomerNo of 000000408 and another has 408.

After loading the data from view, both customers have 000000408 as the customer no in QV.

It looks very strange. Has anyone encountered this error? Any workaround to force QV to take the correct customer no.

Thanks.

Both customers in SQL ViewBoth customers in QV after loading data from the customer view

Re: Qlikview reads data incorrectly from sql

Vegar — Sat, 30 Mar 2019 05:22:05 GMT

You will need to make Qlik believe that your CustomerNo is a string and not a numeric value. The numeric 0000000408 is the same as numeric 408.

Try to do a preceding load
LOAD text(CostumerNo) as CostumerNo

Re: Qlikview reads data incorrectly from sql

mayuranp — Sat, 30 Mar 2019 08:31:18 GMT

Thanks, this worked perfectly 🙂