Qlikview reading field format on reload

[Anonymous]

Hi all,

I'm trying to figure out how QV decides if a certain field is a num or string ? can Qv read a field as Boolean ?

for example my phoneNum  field looks like this 201333455344472 will this be a num or string ?

I read all my data from TXT files does this impact the format ?  would reading from DB change the outcome?

thanks

[#2]

There is no data type in QlikView

If a field is num: it will be stored both num and Text (formatted during script). We talk about DUAL. Phone nr: dual

If the field is text, the dual num part is empty

TXT or DB: no impact (take care that when reading the TXT file, the interpretation is correct especially for dates)

No boolean in QV : 0 is false, <> 0 is true (especially for functions)

Fabrice

[Colin-Albert]

As the number is over 14 digits long it will be loaded as text.

[hic]

If you read a text file, then QlikView tries to interpret each individual value as a number or date. If it succeeds, it will be stored as a dual. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation

HIC