Annapurna1
Contributor III
2021-12-18
02:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Map multiple rows single existing row
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
279 Views
0 Replies