Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-09-26 04:33 AM

Leading zeros

Hi guys.

I need help on an issue. I have a view in sql server that brings two records 014801 and 14801.

These are two different items.When i  make a select from that view on a qvw the result is that it brings only one of the records.

I have tried convert(varchar,item) but it didnt work. Can anyone help?

Labels (1)
Labels
3,016 Views
12 Replies
Not applicable
‎2012-09-26 05:30 AM
Author

In response to sudeep_d

The thing is that I have hundreds of this case, 014802 and 14802,014803 and 14803 and so on...

456 Views
0 Likes
sivarajs
Specialist II
Specialist II
‎2012-09-26 05:51 AM

In response to

This might be you are looking for

Test_1.qvw
1,807 Views
0 Likes
Not applicable
‎2012-09-26 05:53 AM
Author

In response to sivarajs

Thank you!

I added a load statement before the select and it worked!

Thank you all guys!

456 Views
0 Likes