Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

5 Replies
stabben23
Master
Master

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.

daveamz01
Creator III
Creator III

Hi,

You can use Text(Invoice_number):

Untitled.png

Regards,

David

Not applicable
Author

Hi Staffan,

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

Regards

Vijayaraghavan D

Not applicable
Author

Hi David,

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

Regards

Vijayaraghavan D

qlikviewnovice
Specialist II
Specialist II

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