I am new to Qlikview and I cannot figure out how to solve this issue. I have a data island and I want to calculate total payments from this data island. I have a chart that has dimensions of vendor and year. I am trying to figure out the expression to use to pull the correct payment totals. The data island has a Payment Year and Payment Vendor. So basically I want the payment total on each line to be the sum of all payments were Payment Year = the current row’s dimension year and Payment Vendor = the current row’s dimension vendor. I have tried all the following combinations but none of them seem to work. Any help would be greatly appreciated.
Here is a small sample of the qlikview application I have issues with. In the chart there is a column for Payments Total Spend. I am trying to sum up the payments for a particular vendor and year. So I need an expression that will sum the payments where PaymentYear = the dimension year and PaymentVendor = the dimension vendor.