Discussion board where members can get started with QlikView.
I have a table below as shown below. I have my expression for OEC - Current as
=If(Num_Month = '$(vPreYearLastMonth)' and Year = '$(vPreYear)', 0, Sum(Updated_OEC_Budget))
Sum(Updated_OEC_Budget) = 179922+522900 = 702822; but the expression is wrong (Duplicate Values as you see below).
Can anyone help me how to fix these duplicate values? Attached is the qvd and qvw file
=If(Num_Month = '$(vPreYearLastMonth)' and Year = '$(vPreYear)', 0, Sum(AGGR(Updated_OEC_Budget, Cost-Code)))
@jduenyas that expression works for Total, but when I change the Engineering_Area the value becomes 0
@sunny_talwar, @jontydkpi, @swuehl, Can you please look into this problem?
It seems like one of the joins or the logic in the load script is causing duplicate records. Your data model may need to be changed to better suit your analysis.
As a test, try removing the NCC_Code column and see if the duplicates are removed. Looks like you are getting a row for each distinct value of NCC_Code.