This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a column with numbers
987654.20Qlik is ignoring 0 after decimal point. Which is normal. But I want both
1234567.1 & 1234567.10 etc...
I want to bring in anything after decimal without concatenating the numbers
Hello @MK9885 ,
On the first load Qlik already reads it as numeric as the source probably tells Qlik to do. You have to solve this in your SQL statement like this.
LOAD Text(Number) as Number
SELECT CAST(Field AS varchar) as Number
View solution in original post
Do you want these numbers as a dimension or will you use them in a expression. Display versus calculation?
It's a dimension.
As shown below in SQL DB table,
But when I load this in Qlik, it concatenates both numbers & just giving me 4667547.2.
they are 2 separate records.
You can load this field as text if you want to use it as a dimension. Qlik automatically sees this field as numeric, so you have to explicitly tell it is text.
LOAD text([column_with_number]) as column_with_number
, [other column]
FROM [yadiyada.qvd] (qvd);
Didn't though about that..
Thanks. It worked at extract level. Loading in final app to see the results.