Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Annapurna1
Contributor III
Contributor III

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

0 Replies