Format Calc error

Tue, 04 Feb 2014 10:42:26 GMT

Hi all,

I am trying to concatenate two resident tables in one application and calculates one field based in another ones.

When I multiply the field values, the resulting ones are wrong.

I guess this is an formatting issue, cause I am using collon as decimal separator, but I am no sure that,

My regional settings are:

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';
SET DayNames='seg;ter;qua;qui;sex;sáb;dom';

My Concatenate expression is:

TarefasFato:

LOAD

Year(%Data) AS Ano,

Month(%Data) AS Mes,

%Data AS Data,

_Tipo AS _Tipo,

#Tempo AS #Tempo,

INT_CODSIS AS CodSistema,

INT_CODMOD AS CodModulo,

INT_CODUSU AS CodExecutor,

INT_CODRSP AS CodResponsavel,

INT_NOMRSP AS NomeResponsavel,

USU_NOMUSU AS NomeExecutor,

INT_NOMSIS AS DescSistema,

INT_NOMMOD AS DescModulo,

0 AS HorasTrabalhadas,

TempoMin AS TempoMinutos,

INT_VALSAL AS #SalarioHora,

TempoMin*INT_VALSAL AS Custo

RESIDENT TempInterferencias;

CONCATENATE

LOAD

Year(%Data) AS Ano,

Month(%Data) AS Mes,

%Data AS Data,

_Tipo AS _Tipo,

#Tempo AS #Tempo,

TRA_CODSIS AS CodSistema,

TRA_CODMOD AS CodModulo,

TRA_CODUSU AS CodExecutor,

TRA_USURES AS CodResponsavel,

TRA_NOMRES AS NomeResponsavel,

TRA_NOMUSU AS NomeExecutor,

TRA_NOMSIS AS DescSistema,

TRA_NOMMOD AS DescModulo,

TRA_CODPRJ AS %CodProjeto,

TRA_CODPRJ&'-'&TRA_CODFAS AS %CodFase,

TRA_HORAS AS HorasTrabalhadas,

TempoMin AS TempoMinutos,

TRA_VALSAL AS #SalarioHora,

TempoMin*TRA_VALSAL AS Custo

RESIDENT TempTarefas;

My Error is at expression TempoMin*TRA_VALSAL and TempoMin*INT_VALSAL

For example:

TempoMin=150

#SalarioHora=42,9975

Custo=4,47890624989572

Custo Should be 6449,625, right?

I am attaching the base and resulting qvd files too

Any help will be appreciated,

Thanks in advance

Re: Format Calc error

Gysbert_Wassenaar — Tue, 04 Feb 2014 11:01:41 GMT

TempoMin seems to be stored as text strings in the qvd. Try using the num# function when you load it:

num#(TempoMin) as TempoMin

Re: Format Calc error

Tue, 04 Feb 2014 11:05:56 GMT

Yeap!

Thank you Gysbert!

Works fine now!

topic Re: Format Calc error in QlikView

Format Calc error

Re: Format Calc error

Re: Format Calc error