topic Re: EasyQlik Qviewer - different field value in QlikView

EasyQlik Qviewer - different field value

t_donnet — Tue, 31 Jul 2018 12:22:40 GMT

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

Re: EasyQlik Qviewer - different field value

vishsaggi — Tue, 31 Jul 2018 15:22:59 GMT

What is your source data? Excel or something else?

Re: EasyQlik Qviewer - different field value

neelamsaroha157 — Tue, 31 Jul 2018 15:28:15 GMT

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.

Re: EasyQlik Qviewer - different field value

rwunderlich — Tue, 31 Jul 2018 18:06:24 GMT

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

Re: EasyQlik Qviewer - different field value

t_donnet — Thu, 02 Aug 2018 10:59:52 GMT

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

Thanks for your help