GrossWeight

[#1]

Hi,

i have a qlikview document which consolidates orders for example customer a has ordered 2 items which are the same on the same day but with different order numbers

when i produce the table qlikview consolidates these jobs which is fine but i want it to give me the total weight not the consolidated weight ? i hope this makes sense?

at the moment it is removing the *duplicate weight* and only giving me the weight of one for example 1kilo instead of 2

thanks for your time

Jase

[#2]

it might help if you showed some data. Is the weight numeric, it can only sum numbers, not strings.

[#3]

Hi Steve

the Weight is a numbers and not strings if you can see below:

Date

Dcity

DDepot

DID

Dname

Division

GrossWeight

Module ID

Oarea

ODepot

Oname

Ozip

Priority

Volume

#############

Birmingham area

CoP Birmingham

test

3402.680814

6.1.2

DL

LES

Test Company

DL5 6EP

Collection

16.98775

#############

Birmingham area

CoP Birmingham

test

3402.680814

6.1.2

DL

MANCHESTER

Test Company

DL5 6EP

Collection

16.98775

#############

Daventry

CoP Daventry

PDC Daventry

test

3402.680814

7.1.2

DL

LES

Test Company

DL5 6EP

Collection

16.98775

#############

Daventry

CoP Daventry

PDC Daventry

test

3402.680814

7.1.2

DL

MANCHESTER

Test Company

DL5 6EP

Collection

16.98775

the table produces

CalendarYear	CalendarMonthName	CalendarDayName	Jobs	Weight	Volume
2009	May	Mon	2	6,805	34

but if you look at the original data and add the weight up and volume it is treating it as duplicate data

hope this makes sense?

[#4]

Hi Steve

the Weight is a numbers and not strings if you can see below:

Date

Dcity

DDepot

DID

Dname

Division

GrossWeight

Module ID

Oarea

ODepot

Oname

Ozip

Priority

Volume

#############

Birmingham area

CoP Birmingham

test

3402.680814

6.1.2

DL

LES

Test Company

DL5 6EP

Collection

16.98775

#############

Birmingham area

CoP Birmingham

test

3402.680814

6.1.2

DL

MANCHESTER

Test Company

DL5 6EP

Collection

16.98775

#############

Daventry

CoP Daventry

PDC Daventry

test

3402.680814

7.1.2

DL

LES

Test Company

DL5 6EP

Collection

16.98775

#############

Daventry

CoP Daventry

PDC Daventry

test

3402.680814

7.1.2

DL

MANCHESTER

Test Company

DL5 6EP

Collection

16.98775

the table produces

CalendarYear	CalendarMonthName	CalendarDayName	Jobs	Weight	Volume
2009	May	Mon	2	6,805	34

but if you look at the original data and add the weight up and volume it is treating it as duplicate data

hope this makes sense?

[#5]

I assume that's a straight table. You have summarsied by day, so if there are 2 jobs , 6805 looks right. What are the dates - is it all the same date? What expression have you used tosum the weight?

Steve

[#6]

Hi Steve,

6805 isnt correct its only adding together 2 of the 4 jobs its all the same date the only difference between the jobs is the Dcity 2 are going to birmingham and 2 to Daventry.

but my Pivot table is only taking 2 jobs and not the 4 ?

does this make sense? 😜 on the weight field on the pivot table im using just Sum (GrossWeight)

[deepakk]

HI Westie,

It seems there is some problem in your data modelling. Such error occurs when the linking between tables are wrong.

If you can show the table and the linking we might able to help you out.

[llauses243]

Hi,

to test aggr(nodistinct Sum (GrossWeight))

good luck, Luis

[#9]

Hi Luis,

i tired that and it gives me a - in the gross weight field?

[#10]

Hi Deepak,

i cant give you the data as its customer data otherwise i would.