I have a problem with my visualizations on QlikView. I want to calculate Quantity per Month based on the value from the Quantity and per Code itself (Code field contain several values also).
Currently, my aggregate function not showing on all rows as you can see like the sample below:
It only shows on one row and showing NULL on other rows. What I want is to show it on all rows.
1. The red marked are the expressions (Month & Qty per Month)
Month = Date([Date of Transaction]),'MMMYY')
Qty per Month = Aggr(Sum([Quantity]),[Month],[Code])
2. Somehow, I can't solve this by Editing the Script, I can only work this by using expressions.
3. Please assume that all fields have other values also, not like the sample above.
Thank you and hopefully I get feedback very soon from the forum.