Pivot table totals across the top repeating same...

[bjjackson2760]

Hello all,

I am new to Qlikview and while the simple 1 or 2 table reports were simple enough, the request I am receiving are getting more complex.  Currently I am learning to work with QVDs.  I am trying to do a pivot table, but the totals are repeating themselves across the rows.  Could it be a problem with my load?  I would think that the sum(actl_batch_qty) in the expression would have gave me the correct totals across the top, but no.  Please help.  Attached is the outcome and below is my load, but please this is my first attempt to use Qualify and Unqualify:

QUALIFY*;
UNQUALIFY  item_code;
LOAD BATCH_CODE as batch_code,
INVY_ITEM_CODE,
ITEM_CAT,
ITEM_CODE as item_code
FROM

(qvd);

QUALIFY*;
UNQUALIFY item_code, loc_code;
LOAD item_code,
loc_code,
batch_code

FROM

(qvd);

QUALIFY*;
UNQUALIFY  tkt_code, plant_code;
LOAD  Year(order_date) as Year,
month(order_date) as Month,
Day(order_date) as Day,
order_date,
tkt_code,
actl_batch_qty,
delv_qty,
ship_plant_code as plant_code,
batch_code
FROM

(qvd);

QUALIFY*;
UNQUALIFY  tkt_code;
LOAD Year(order_date) as Year,
month(order_date) as Month,
Day(order_date) as Day,
order_date,
tkt_code,
const_prod_code,
actl_batch_qty
FROM

(qvd);

QUALIFY*;
UNQUALIFY plant_code, loc_code;
LOAD  plant_code,
comp_code,
name,
short_name,
loc_code
FROM

(qvd);

[sunny_talwar]

What is the expression you are using in your chart? Would you be able to share you qvw file?

[bjjackson2760]

sorry, I cannot do that, but the expression is sume(actl_batch_qty).

[bjjackson2760]

I mean sum(actl_batch_qty), thanks Sunny.

[ecolomer]

Can you explain more your requeriment ?

Can you upload a data example?

[bjjackson2760]

Hi Enrique,

I don't understand what you are asking.  I have uploaded the loadscript and the outcome of it is also included.

[bjjackson2760]

if you scroll from the bottom across you can see the column totals repeated even though the demension is changing across the top.

[sunny_talwar]

Can you share an image of your data model? With so many things Qualified, it is difficult to know how your data model looks like

[bjjackson2760]

Hi Sunny, I have attached the Model, please help.  Thanks.