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.
In the table above I have used the expression
$(vBalance)+RangeSum(Above(TOTAL Column(1) - Column(2), 0, NoOfRows(TOTAL)))
to get the Balance column. Now I need to represent the same data in a pivot table as follows
I've used ($(vBalance)+RangeSum(before(TOTAL sum(Arrival) - sum(Dispatches), 0, ColumnNo(TOTAL))))
which gives the 1st row(for Jan) of the pivot table right.But gives incorrect results for the other rows.
I have attached the application I've been working.
Can anyone help me with creating the table I wish for?