topic Re: Field value changes after loading into qlikview in QlikView

Field value changes after loading into qlikview

manisha_uit — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have a field runtime in db which has data in the format (ex. 9h:5m). When I load this into qlikview, the data changes to some weird values as 10278h:56m

I tried using text(field) but not getting the correct data.

Please suggest

Thanks,

Manisha

Re: Field value changes after loading into qlikview

qlikviewwizard — Wed, 30 May 2018 16:02:48 GMT

How you are loading into Qlikview?

Database to QVDs?

Database to QVW?

Re: Field value changes after loading into qlikview

manisha_uit — Wed, 30 May 2018 16:03:28 GMT

Database to qvw directly

Re: Field value changes after loading into qlikview

qlikviewwizard — Wed, 30 May 2018 16:06:10 GMT

Can you load into QVD and check?

Re: Field value changes after loading into qlikview

vishsaggi — Wed, 30 May 2018 16:31:57 GMT

Can you share some part of your script on how you getting this field? And what should be your expected values to see once you get into qvw?

Re: Field value changes after loading into qlikview

mrichman — Wed, 30 May 2018 19:34:03 GMT

Hi Manisha,

Check tab 'Main' in scripting mode. Maybe your sets are not correct.

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;€ -#.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='D-M-YYYY';

SET TimestampFormat='D-M-YYYY hh:mm:ss[.fff]';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

SET FirstMonthOfYear=1;

SET CollationLocale='nl-NL';

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

SET LongMonthNames='januari;februari;maart;april;mei;juni;juli;augustus;september;oktober;november;december';

SET DayNames='ma;di;wo;do;vr;za;zo';

SET LongDayNames='maandag;dinsdag;woensdag;donderdag;vrijdag;zaterdag;zondag';

Re: Field value changes after loading into qlikview

manisha_uit — Thu, 31 May 2018 03:37:58 GMT

Checked loading into QVD. Still remains the same.

Thanks,

Manisha

Re: Field value changes after loading into qlikview

manisha_uit — Thu, 31 May 2018 03:38:53 GMT

Hi Richman,

I checked the variables. They seem to be correct.

Thanks,

Manisha

Re: Field value changes after loading into qlikview

tamilarasu — Thu, 31 May 2018 03:48:21 GMT

Hi Manisha,

Could you provide below details to help you further.

1) Your script

2) Snapshot of your DB field

3) Snapshot of Qlikview field (after loading)

Re: Field value changes after loading into qlikview

jyothish8807 — Thu, 31 May 2018 05:15:42 GMT

Hi Manisha,

Try like this in in your qlikview load:

load

time#(runtime,'hh:mm' ) as runtime

from <>

if you want to use this field for further calculation then, try like this:

load

time(replace(replace(time#(runtime,'hh:mm' ),'h',''),'m',''),'hh:mm') as runtime

from <>

Hope this help.

Br,