# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New Contributor III

## Strange Sum-result in Qlikview

Dear Qlikviewers,

I am encountering a issue where I don't understand why Qlikview applies the logic that it does.

Let me explain below.

I have a database with two tables (simplified example below):

ShipmentdateShipmentdate

After loading, I make a straight table, which ends up like this:

We see the Shipmentdate from both tables as the key, the MTD_BusinessDay from the right table and the SHP from the left.

So far, so good. However, when you manually add up the figures, you come to 1.239.298 instead of the 1.112.575 Qlikview shows.

I have found out what happens: in the table, you can see that MTD_BusinessDay 8 and 13 both have 14-4-2014 as Shipmentdate.

This is intentional, so this is exactly like it's supposed to be. However, Qlikview now only adds ONE of the two in the SHP-total.

The formula used for the SHP is:

where vYesterdayLastYear = 23-4-2014.

My question now is: why does Qlikview only add the SHP once when calculating the total?

And: is there a way to force Qlikview to make the right sum?

KR,

Stefan

Tags (2)
1 Solution

Accepted Solutions

## Re: Strange Sum-result in Qlikview

Hi,

Use AGGR()

try below

In Aggr() write your dimension of chart.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
3 Replies

## Re: Strange Sum-result in Qlikview

Hi,

Use AGGR()

try below

In Aggr() write your dimension of chart.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
New Contributor III

## Re: Strange Sum-result in Qlikview

Like a charm! Can't believe I have been searching for 30 minutes and didn't think of this... Thansk a lot Max!

## Re: Strange Sum-result in Qlikview

You Welcome

Great dreamer's dreams never fulfilled, they are always transcended.