topic Re: Help with Pivot table Sum in QlikView

Help with Pivot table Sum

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

Hi,

I have some data in which I want to show how much orders i received vs produced & remaining.

Every order has its line items.

Eg :

Order Line qty

A 1 2

A 2 32

Produced values are coming from another schema. Used load script like.

Order

;

left join

Production.

on order no=orderno and

Lineno=lineno

;

After loading data m trying to get sum in Pivot table.

Highlighted row shod show me 10 , also if i clear other selections its showing me 10 against every line item.

used formulas:

exp1: tied two with same result.

= sum([Weight (in MT)]

and

=aggr(sum([Weight (in MT)]),[Agent Name],
[Customer Name],Dim_Ord_No,[DIM Sub_Order No])

exp2: sum(produ)

exp3=sum([Weight (in MT)] -sum(produ)

Need help to get this correct.

Thank you in advance for you suggestions.

sushil353 — Fri, 18 Aug 2017 05:59:17 GMT

Hi,

if possible upload a sample application and what should be desired output of the table

Anonymous — Fri, 18 Aug 2017 06:01:32 GMT

Actually,

Values in first expression are like below, in previous image its now showing decimal values,

The total is 10.5

Anil_Babu_Samineni — Fri, 18 Aug 2017 06:27:32 GMT

As Sushil state, You must clear that and share some work file to work / test. For a while perhaps this?

= sum(TOTAL <Dim_Ord_No> [Weight (in MT)]

Anonymous — Fri, 18 Aug 2017 07:07:16 GMT

Thank you Anil & Sushil for your reply.

I will try what you mentioned & will create a sample file to upload.