Discussion Board for collaboration on QlikView Scripting.
I am having trouble with qlikview when loading a very specific set of data. For some strange reason, QV does not recognize "0E0" and "0E1" as different data values. When loading the following table, qv reads 5 records but only 4 distinct values.
this is the script:
T_Table:LOAD * INLINE [Field0E10E0AAABBBCCC];
I would appreciate if anyone knows how to fix this.
Go to Solution.
That is weird. I can't say I know why it is happening.
To fix it, you should format the field as Text, use:
T_Table:LOAD Text(Field) As Field INLINE [ Field 0E1 0E0 AAA BBB CCC];
EDIT: Could QlikView be treating it as scientific notation? 0 x 10^1 and 0 x 10^0 would both be zero?
Your observation looks correct since =1E0*5 in QlikView equals 5 and QlikView treats 0A1 and 0A0 as distinct.
NMiller, thanks for your help.