Discussion Board for collaboration on QlikView Scripting.
I have data like this
A, B, C, Code, Amount
1, 2, 3, PC, 900
1, 3, 4, PM, 800
1, 2, 4, TM, 800
1, 2, 6, PC, 800
I have to merge first two rows and amount should be 1800.
Go to Solution.
Try like this
Load A,B,C, Sum(Amount) as Amount, Code Group by A,B,C, Code;Load * inline[ A, B, C, Code, Amount 1, 2, 3, PC, 900 1,2,3,PC,900 1, 3, 4, PM, 800 1, 2, 4, TM, 800 1, 2, 6, PC, 800 ];
Create a straight table chart.
Add fields A, B, C and Code as dimension
Create a formula sum(Amount)
This will show you the wanted value.
In the front -end if you use aggregation function Sum() with other dimensions in a chart you get it as you want. If you are looking for script solution try like:
Sum(Amount) as Amount
Resident Input Group By A, B, C, Code;
Drop Table Input;
Create New Chart --> Straight Table