Issue while fetching invoice number 0615 and 615 from a table.

[#1]

Hi All,

I have a table named 'abcd' with the field name Invoice_Number and its a varchar field. The issue is, invoice_number field has two different values 0615 and 615 with amount field. But when i fetching these records in a qvw its shows one single value as 0615, qlikview considers 615 as 0615. Please find the below real time example for better understanding. What can be done to overcome this issue.

Example:

In DB table:

Invoice_number    Amount

0615                    1000

615                      500  

After loading it in qlikview:

Invoice_number    Amount

0615                    1000

0615                      500  

Regards

Vijayaraghavan D

[stabben23]

Hi,

You have to make Your Invoice_number to text, like text(Invoice_number) as Invoice_number

Qlikview is so "smart" that he thinks that 615 is the same as 0615 and "help" you to format.

Qlikview is also so smart that he keeps the first read value in mind, so if you change so you read 615 first, both will be 615.

[daveamz]

Hi,

You can use Text(Invoice_number):

Regards,

David

[#4]

Hi Staffan,

I tried Text(), it works. Thanks for your effort to resolve my issue.

Regards

Vijayaraghavan D

[#5]

Hi David,

I tried Text(), it works. Thanks for your example.

Regards

Vijayaraghavan D

[Anonymous]

Please close the thread by marking " Correct " or" Helpful " if you got the solution.