Discussion Board for collaboration on QlikView Scripting.
please guide me
I have table similar below :
I need total breakdown of order number ( Ord_No ) and invoice number ( Inv_No ) ???
In a expression to this form of writing :
sum ( Amount ) / sum ( TOTAL< Ord_No , Inv_No > Amount )
Please advise me what code to write the script as new variable ???
Hope below script meets your requirement
sum(Amount) as Amount_Per_Inv
group by Ord_No,Inv_No;
Load *, Amount/Amount_Per_Inv as Avg_Amt
Drop Table Inv_Table_Temp;
View solution in original post
what do you mean by breakdown?
Can you explain a sample output
sorry I mean ... I need the total amount per (Ord_No) and (Inv_No) in script
What solution can you suggest