Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Pivot table totals across the top repeating same...

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

8 Replies
Highlighted

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

Highlighted
Contributor
Contributor

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

Highlighted
Contributor
Contributor

I mean sum(actl_batch_qty), thanks Sunny.

Highlighted
Master II
Master II

Can you explain more your requeriment ?

Can you upload a data example?

Highlighted
Contributor
Contributor

Hi Enrique,

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

Highlighted
Contributor
Contributor

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

Highlighted

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

Highlighted
Contributor
Contributor

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