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.
I am trying to produce a pivot table around dates and to sum data up until the dimension.
I have tried using a sum(if( statement but I cant get this to work. The application works off two table (costs and accounts). The costs are updated at regular intervals which formulate the date.
The result I am trying to acheive is below:
Can anyone help?
You'll want to add a distinct since for every record in Accounts, you have four in Claims. Try:
Sum(distinct If( Transaction <= LoadDate , Amount, 0))
View solution in original post
That works; thanks for that.