Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts,
I have an issue related to decimal field. I have two fields having value
2.1 abc
2.2 xyz
2.3,
2.4,
2.5,
2.6,
2.7,
2.8,
2.9,
2.10 pqr
The issue is that qlikview takes the value 2.1 abc and 2.1 pqr,
while I need the output as 2.1 abc and 2.10 pqr. Please help me in this
hi
Try with
Text(FieldName1) as FieldName1;
Hope it helps
Load the value as text in your load script.
HTH Andy
hi
Try with
Text(FieldName1) as FieldName1;
Hope it helps
These two values are the same number for QV, and there is only one format for a single number.
You can use
LOAD
text(FIELD1) as FIELD1,
FIELD2,
...
to read the numbers in as text.
Hi Rahul,
Try to load value with dual i.e one as text and one as number.
dual(text(numberfield),numberfield)
Hi All, I tried loading field using text still the same.
Text(Wbs) as wBS
can you share the app with sample data
What is your data source?
edit: Here is a sample for an INLINE LOAD:
LOAD Text(Field1) as Field1, Field2
INLINE [
Field1, Field2
2.1, abc
2.2, xyz
2.3,
2.4,
2.5,
2.6,
2.7,
2.8,
2.9,
2.10, pqr
];
Hi Rahul,
can you upload your qvw and sample date? Or failing that; your data and the relevant script please?
Andy