Discussion Board for collaboration on QlikView Scripting.
Hello Qlikview experts,
I am a newbee on Qlikview.
I use Qlikview 7.5.
I wan to create a sales report.
Need a formula to calculate new field “Sum” wich is the sum of field Quantity where the fields “Cust”, “Item Numb”, “Customer Item and “”Month” are same.
Any help will be apreciated,
If you want to calculate the sum in script, the following may help you:
If the detailed data table name is Details
NoConcatenate LOAD Cust, [Item Numb], [Customer Item], Month, Sum(Quantity) as SumQty
resident Details Group By Cust, [Item Numb], [Customer Item], Month;
If you want to display the sum on a chart, create a pivot table chart with Cust, [Item Numb], [Customer Item], Month as dimensions and Sum(Quantity) as expresion.
Hope this helps.
Thanks for your reply.
As i am running Qlikview 7.5 function Concatenate doesn't work. Is there an other solution?
Did you try with 'NoConcatenate' prefix?
Here the script.
FROM [..\..\..\xxx\omzet\SO 2013-01-08.xls] (biff, embedded labels, table is [Blad2$]);
How should it look with Concatenate expression?
Try the following. You may have synthetic key, but I think it will not affecf the result.
FROM [..\..\..\xxx\omzet\SO 2013-01-08.xls] (biff, embeddedlabels, table is [Blad2$]);
Sum(Quantity) as SumQty
Group By Cust, [Item Number], [Customer Item], Month;
I do not have access to Qlikview version 7.5 in order to test the above script.