This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I want to merge multiple rows of BranchName into one row i,e BranchName1 and sum the TW count and TW value to one Row.
This is my Qlik Output
But my Expected output should be
Please find script for your reference.
BranchDetails:LOAD [Sr No], Capitalize (Zone) as Zone, Capitalize(State) as State, City, BranchName, BranchName1, [Branch ops Region], [RM Name], [Branch Ops], [Manpower Count],If([Manpower Count]=1, 'Single', If([Manpower Count]>1,'Multiple', 'NA')) as "Single Manpower"FROM[C:\Users\ADMIN\Desktop\BranchDetails\Branch details.xlsx](ooxml, embedded labels, table is Sheet1);
BookSize:LOAD TW_AgreementNo, BookSize as TWBOOKSIZEFROM..............;
Agreement:LOAD TW_AgreementNo, Capitalize (BranchName) as BranchNameFROM...........;