topic Re: Divide gives incorrect value in QlikView

Divide gives incorrect value

Anonymous — Mon, 02 Mar 2015 07:22:30 GMT

Hi,

I did some expression as follows

num($(vACD_HoldTime)/$(vACD_Handle_Time),'###.###') gives 2.000 value.

based on the my analysis vACD_HoldTime gives 0 value and vACD_Handle_Time gives 40 value.when we do divide function it has to display 0 but it shows 2.000 value. Please help me,

Thanks,

Re: Divide gives incorrect value

PrashantSangle — Mon, 02 Mar 2015 07:30:36 GMT

Hi,

If possible post your application??

if not then post $(vACD_HoldTime) and $(vACD_Handle_Time) variable expression..

Regards

Re: Divide gives incorrect value

Anonymous — Mon, 02 Mar 2015 07:36:50 GMT

Hi max,

Thanks for your reply,App size is huge,

My formulas are

vACD_HoldTime=sum({<PeripheralCallType = {'2'}>} HoldTime)

vACD_Handle_Time=$(vACD_TalkTime)+$(vACD_WorkTime)+$(vACD_HoldTime)

Thanks,

Re: Divide gives incorrect value

PrashantSangle — Mon, 02 Mar 2015 07:40:49 GMT

Hi,

Are you using it in chart or text Object?

Also check individually vACD_HoldTime and vACD_Handle_Time in text object.

Regards,

Re: Divide gives incorrect value

prieper — Mon, 02 Mar 2015 07:45:47 GMT

Suggest to

a) leave away for a moment the formatting (NUM)

b) enter both parts with "="-sign into a textobject and check the resulting values manually on correctness/plausibility.

c) if both correct, the result should be as well.

HTH Peter

Re: Divide gives incorrect value

Mon, 02 Mar 2015 07:46:18 GMT

I guess i the problem is a missing bracket, but without data we can only guess

sum({<PeripheralCallType = {'2'}>} HoldTime) / $(vACD_TalkTime) + $(vACD_WorkTime) + $(vACD_HoldTime)

When dividing and multiplying with variables, always make some outer brackets to be safe, even if not needed:

try

/e fixed

num(

($(vACD_HoldTime)) / ($(vACD_Handle_Time))

,'###.###,')

It could also be caused of a one to many data situation, as the first variable includes a sum aggregation and the second doesn't - or probably double data entries which arent shown when getting the data in a listbox without unique ID

Re: Divide gives incorrect value

Anonymous — Mon, 02 Mar 2015 08:22:41 GMT

Hi marcus,

Thanks for your reply.its working fine.Yes its brackts issue.

Now i got currect result.

Thanks,