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 happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Annapurna1
Contributor III
Contributor III

Map Rows

Hi,

I want to map rows of BranchName with my existing row BranchName1.

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