topic Re: Making a New Cummulative Field from existing 2 fields in QlikView

Making a New Cummulative Field from existing 2 fields

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

Hi All,

I have 2 fields Dealer Code, Parent Dealer Code . Both fields have value against them. I need to club the data for Parent Dealer Code + Dealer code to get cummulative sum of value of both .

Parent Dealer Code	Dealer Code
P1	A1
P1	A2
P2	B1
P2	B2
P2	B3

Parent Code	Value
P1	56
P1	56
P2	70
P2	70
P2	70

Dealer Code	Value
A1	50
A2	10
B1	29
B2	40
B3	60

I thought to create a new dealer field to get cummulative sum of value of both fields regardless of any field(Parent Dealer Code Or Dealer code) value selection I want to create a "NewField" to get cummulative sum on front end . Please help.

NewField	Dealer Code	Value
P1	P1	116
P1	A1	116
P1	A2	116
A1	P1	116
A1	A1	116
A1	A2	116
A2	P1	116
A2	A1	116
A2	A2	116

Re: Making a New Cummulative Field from existing 2 fields

effinty2112 — Sat, 02 Sep 2017 12:52:51 GMT

Hi Apoorva,

This is your data in one table:

Parent Dealer Code	Dealer Code	ParentValue	DealerValue
P1	A1	56	50
P1	A2	56	10
P2	B1	70	29
P2	B2	70	40
P2	B3	70	60

What is the logic to get from the above to:

NewField	Dealer Code	Value
P1	P1	116
P1	A1	116
P1	A2	116
A1	P1	116
A1	A1	116
A1	A2	116
A2	P1	116
A2	A1	116
A2	A2	116

Regards

Andrew

Re: Making a New Cummulative Field from existing 2 fields

Anonymous — Sat, 02 Sep 2017 18:32:04 GMT

Hi, I want to show Value : 16462715 and Qty 2975 against any parent dealer code or any Dealer code . Both should have same value which is = Parent value+ child Value

ParentDealerCode	DealerCode	ParentChildStatus	Value	Qty
			16462715	2975
ANDD0711	ANDD0711	Parent	11353561	2276
ANDD0711	TELD001155	Child	5109154	699

Re: Making a New Cummulative Field from existing 2 fields

Anonymous — Sat, 02 Sep 2017 18:36:13 GMT

I want to Clubb data for all parent and child codes .