Calculation in line chart not totaling up correctly

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

I have 5 different charts with different calculations that when I am just looking at 1 customer the number is correct but when I look at total company it is not correct. I will give 1 chart as 1 example.

In one of the charts I am trying to calculate the seatbelt exceptions.

So in the line chart it is by date for the dimensions and for the expression I first tried this calculation and I was not getting any of the correct calculations for 1 customer on one date or correct calculations for total company.

the calculation should give me (if I could get it correct) on date 6/5/2017 1 customer (customer number 2) 3663 and for total company on that date it should give me 9963.

Try 1:

round(Sum({<FileDate = >}([Total Distance Miles] / Seatbelt)))

This gave me 1 customer = 896 and total company = 22088

Try2:

Next I have tried doing the calculation in the script.

So something like this:

LOAD

if((S10 + HB + SB + HA)=0,0,

round(TDM / SB) as SeatBeltS;

LOAD

Sum ([Total Distance Miles]) as TDM,

Sum (Seatbelt) as SB

Resident Scorecard;

and then I did this for the expression

Sum({<FileDate = >}(SeatBeltS))

This gave me for 1 customer = 3663 (which is correct) but for total company = 58494 (which is wrong)

I do not know what I need to do to get the total company to show the correct number?

Re: Calculation in line chart not totaling up correctly

Anonymous — Fri, 26 May 2017 12:45:46 GMT

I figured out what I need to do. For anyone in the future who might need this answer I had to sum up each by themselves.

round(sum({<FileDate = >}[Total Distance Miles]) / sum({<FileDate = >}Seatbelt))

topic Re: Calculation in line chart not totaling up correctly in QlikView

Calculation in line chart not totaling up correctly

Re: Calculation in line chart not totaling up correctly