Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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]
Thank You. It Worked