Field value changes after loading into qlikview

[manisha_uit]

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

[qlikviewwizard]

How you are loading into Qlikview?

Database to QVDs?

Database to QVW?

[manisha_uit]

Database to qvw directly

[qlikviewwizard]

Can you load into QVD and check?

[vishsaggi]

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?

[mrichman]

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';

[manisha_uit]

Checked loading into QVD. Still remains the same.

Thanks,

Manisha

[manisha_uit]

Hi Richman,

I checked the variables. They seem to be correct.

Thanks,

Manisha

[tamilarasu]

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)

[jyothish8807]

Hi Manisha,

Try like this in in your qlikview load:

load

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

from <>

or

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,

KC