EasyQlik Qviewer - different field value

[t_donnet]

Hello,

During some test for an app, I couldn't manage to understand while selecting a value (3600) from this specific field doesn't work.

After investigation, with the easyQlik Qviewer, the value seems to be a different format. The field as numeric and integer tags.

I don't understand how come this value can be different. All values are load the same way.

Any ideas? best way to correct?

Thanks for you help

[vishsaggi]

What is your source data? Excel or something else?

[neelamsaroha157]

may be while loading the field, explicitly define the format either text or num as per your requirement. If all the values are not in the same format try using Text# or Num# resp.

[rwunderlich · Accepted solution]

The value was likely loaded as a Dual.  The F2 values display shows the string value if a Dual. To confirm, right-click on the 3600 value in the Table display and select "Metadata".

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

[t_donnet]

Effectively the value '3600' was in Num(Int) and the others values in Dual(Int).

Thanks for your help