topic Re: Pivot table totals across the top repeating same... in QlikView

Pivot table totals across the top repeating same...

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

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);

Re: Pivot table totals across the top repeating same...

sunny_talwar — Fri, 19 Aug 2016 21:08:02 GMT

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

Re: Pivot table totals across the top repeating same...

bjjackson2760 — Fri, 19 Aug 2016 21:19:53 GMT

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

Re: Pivot table totals across the top repeating same...

bjjackson2760 — Fri, 19 Aug 2016 21:20:39 GMT

I mean sum(actl_batch_qty), thanks Sunny.

Re: Pivot table totals across the top repeating same...

ecolomer — Fri, 19 Aug 2016 21:21:23 GMT

Can you explain more your requeriment ?

Can you upload a data example?

Re: Pivot table totals across the top repeating same...

bjjackson2760 — Fri, 19 Aug 2016 21:24:41 GMT

Hi Enrique,

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

Re: Pivot table totals across the top repeating same...

bjjackson2760 — Fri, 19 Aug 2016 21:25:54 GMT

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

Re: Pivot table totals across the top repeating same...

sunny_talwar — Fri, 19 Aug 2016 21:48:02 GMT

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

Re: Pivot table totals across the top repeating same...

bjjackson2760 — Mon, 22 Aug 2016 02:15:16 GMT

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