This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
does anyone know why my partial sum on the pivot table does not want to show?
I think all you might need is to surround your expression with Sum(Aggr(....., Dimensions))
View solution in original post
What is your expression that you are using?
maybe because one of the rows contains null in the value you are using
and the grouping function used returns null if one of the value is null
can you add selection boxes on these fields to see if there is any data or not ?
my expressions are as follows (i have 4):
1. Average monthly forecast (cases):
(sum ([Annual Sales])*-1/12 * (1 + ((sum([3 Months Sales]) - sum([Prior Year 3 Months Sales]))
sum([Prior Year 3 Months Sales])))
[FG Case weight])
(sum([3 Months Sales])*-1/3) / [FG Case weight]
[FG Case weight]) )
2. Number of pallets:
[FG Case weight]) ) )
[FG Pallet Size]
3. Planned production (cases):
* [FG Pallet Size]
4. Planned production (kg):
*[FG Case weight]
But I have created Dimensions using Valuelist and Still I don't see the SUM.