Hi,
I have Multiple branches in city ahmedabad but i want to show count of all the branches with only one branchname1 as shown below.
I want to map rows of BranchName with my existing row BranchName1. Where TW Count and TW Value are measures.
This is Qlik output.
| Sr No |
Zone |
State |
City |
BranchName |
BranchName1 |
Branch ops Region |
RM Name |
Branch Ops |
Manpower Count |
Single Manpower |
TW Count |
TW Value in CR |
| 3 |
West |
Gujarat |
Ahmedabad |
Ahmedabad- **bleep**al Varsha |
Ahmedabad- Navrangpura |
WEST 2 |
Pragnesh Patel |
Yes |
6 |
Multiple |
0 |
0 |
| - |
West |
Gujarat |
Ahmedabad |
Ahmedabad-Ambavadi |
Ahmedabad- Navrangpura |
WEST 2 |
Pragnesh Patel |
- |
6 |
Multiple |
0 |
0 |
| - |
West |
Gujarat |
Ahmedabad |
Ahmedabad-Ambavadi-2 |
Ahmedabad- Navrangpura |
WEST 2 |
Pragnesh Patel |
- |
6 |
Multiple |
105694 |
229.7152379 |
| - |
West |
Gujarat |
Ahmedabad |
Ahmedabad-C.G Road |
Ahmedabad- Navrangpura |
WEST 2 |
Pragnesh Patel |
- |
6 |
Multiple |
0 |
0 |
| - |
West |
Gujarat |
Ahmedabad |
Ahmedabad-C.G Road-160 |
Ahmedabad- Navrangpura |
WEST 2 |
Pragnesh Patel |
- |
6 |
Multiple |
163981 |
1.469091526 |
But my expected output is, Both the branch names should be mapped and the count of TW and TW value should also be add with each other
| Sr No |
Zone |
State |
City |
BranchName1 |
Branch ops Region |
RM Name |
Branch Ops |
Manpower Count |
Single Manpower |
TW Count |
TW Value in CR |
| 3 |
West |
Gujarat |
Ahmedabad |
Ahmedabad- Navrangpura |
WEST 2 |
Pragnesh Patel |
Yes |
6 |
Multiple |
2,69,675 |
231.17 |
Help me out
