Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
PraveenNavara
Contributor II
Contributor II

Missing Values in QV Document

Hi, 

I am connecting to SQL Server Source , extracting data from table with 1 column(nvarchar) and 2 records (123 , 0123) using Select statement with out any filters. 

When i use list box i only get 0123 not 123. Can you please help me here. 

Regards

Praveen

1 Solution

Accepted Solutions
Colin-Albert

When Qlik loads your data, it reads the first value 0123, and recognises this as an integer 123 and stores the data as 0123.

When the second value 123 is loaded, Qlik recognises that data for 123 already exists, so stores the same value again for the second row. Hence you only see the value 0123 for both rows that are loaded in your Qlik data.

You either need to cleanse your data, or if you want 0123 and 123 stored as separate values, use the text() function in your load script.

text(columnX) as columnX

 

 

View solution in original post

5 Replies
m_woolf
Master II
Master II

It's difficult to answer without seeing your load script and your data. Here'a a guess. Go to your listbox properties and change presentation|alignment|numbers to left.

PraveenNavara
Contributor II
Contributor II
Author

Hi ,
This is my Load Script
Item_Filter:
SQL SELECT
*
FROM [DM_SER].[Dim].[Item] // Fetches 37 Million Records out of which 135161 has 18 records and 0135161 has 20 records

;


ItemTmp_Filter:
LOAD
RowNo() as rowid,
Master_ItemNumber as Item_Filter ,
Master_ItemName as ItemName_Filter
Resident Item_Filter
where text(rtrim(ltrim(Master_ItemNumber)))='135161'; // Even then its giving only 0135161 in list box not actual filtered value

drop table Item_Filter;
Colin-Albert

When Qlik loads your data, it reads the first value 0123, and recognises this as an integer 123 and stores the data as 0123.

When the second value 123 is loaded, Qlik recognises that data for 123 already exists, so stores the same value again for the second row. Hence you only see the value 0123 for both rows that are loaded in your Qlik data.

You either need to cleanse your data, or if you want 0123 and 123 stored as separate values, use the text() function in your load script.

text(columnX) as columnX

 

 

Colin-Albert

Try this...

 

Item_Filter:

RowNo() as rowid,
text(Master_ItemNumber) as Item_Filter ,
Master_ItemName as ItemName_Filter ;

SQL SELECT
*
FROM [DM_SER].[Dim].[Item]

PraveenNavara
Contributor II
Contributor II
Author

Thank You. It Worked