Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
You can use Text(Invoice_number):
Regards,
David
Hi Staffan,
I tried Text(), it works. Thanks for your effort to resolve my issue.
Regards
Vijayaraghavan D
Hi David,
I tried Text(), it works. Thanks for your example.
Regards
Vijayaraghavan D
Please close the thread by marking " Correct " or" Helpful " if you got the solution.