Qlikview reads data incorrectly from sql

[mayuranp]

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

[Vegar · Accepted solution]

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

[mayuranp]

Thanks, this worked perfectly 🙂