Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Making a New Cummulative Field from existing 2 fields

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 CodeDealer Code
P1A1
P1A2
P2B1
P2B2
P2B3

Parent CodeValue
P156
P156
P270
P270
P270

  

Dealer CodeValue
A150
A210
B129
B240
B360

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.

   

NewFieldDealer CodeValue
P1P1116
P1A1116
P1A2116
A1P1116
A1A1116
A1A2116
A2P1116
A2A1116
A2A2116
3 Replies
effinty2112
Master
Master

Hi Apoorva,

This is your data in one table:

Parent Dealer Code Dealer Code ParentValue DealerValue
P1A15650
P1A25610
P2B17029
P2B27040
P2B37060

What is the logic to get from the above to:

NewFieldDealer Code       Value
P1P1116
P1A1116
P1A2116
A1P1116
A1A1116
A1A2116
A2P1116
A2A1116
A2A2116

?

Regards

Andrew

Anonymous
Not applicable
Author

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

   

ParentDealerCodeDealerCodeParentChildStatusValueQty
164627152975
ANDD0711ANDD0711Parent113535612276
ANDD0711TELD001155Child5109154699
Anonymous
Not applicable
Author

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