I've created a script for your need, that gets each row and transforms it into two rows in a new table, containing the two possible types os comission and values.
I copied your example to a spreadsheet so i could load it into Qlik
Here's the script:
Data: LOAD Bank, [Id Operation], [Operation amount], [Type of Commission 1], [Commission amount 1], [Type of Commission 2], [Commission amount 2] FROM [C:\Users\sbt43959\Desktop\sample.xlsx] (ooxml, embedded labels, table is Plan1); for each BankID in FieldValueList('Bank') NoConcatenate _tmpTable: Load Bank as _tmpBank, [Id Operation], [Type of Commission 1], [Commission amount 1], [Type of Commission 2], [Commission amount 2] Resident Data where Bank='$(BankID)'; for i = 0 to NoOfRows('_tmpTable') let j = $(i)+1; let _tmpIdOperation = peek('Id Operation',0,'_tmpTable'); let _tmpTypeComission = peek('Type of Commission $(j)',0,'_tmpTable'); let _tmpTypeAmount = peek('Commission amount $(j)',0,'_tmpTable'); [Comission Amount]: Load '$(BankID)' as Bank, '$(_tmpIdOperation)' as [Id Operation New], '$(_tmpTypeComission)' as [Type of Comission New], '$(_tmpTypeAmount)' as [Commission Amount] AutoGenerate(1); next; drop table _tmpTable; next;
As a result, I get
Attached the QVW i used.
PS: Just know I saw you cant access the script, but as to my opinion, it would be quite difficult and rather not possible to do it in a graph without data transformation.
sample.qvw 127.0 K