topic Re: Error in Expression - Duplicate Values in QlikView

Error in Expression - Duplicate Values

bhaveshp90 — Sat, 16 Nov 2024 04:49:19 GMT

Hello,

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

thanks

Bhavesh

Re: Error in Expression - Duplicate Values

jduenyas — Tue, 08 Jan 2019 20:15:08 GMT

try this:

=If(Num_Month = '$(vPreYearLastMonth)' and Year = '$(vPreYear)', 0, Sum(AGGR(Updated_OEC_Budget, Cost-Code)))

Re: Error in Expression - Duplicate Values

bhaveshp90 — Tue, 08 Jan 2019 20:31:36 GMT

@jduenyas that expression works for Total, but when I change the Engineering_Area the value becomes 0

Re: Error in Expression - Duplicate Values

bhaveshp90 — Tue, 08 Jan 2019 20:51:24 GMT

@sunny_talwar, @jonathandienst, @swuehl, Can you please look into this problem?

Re: Error in Expression - Duplicate Values

jonathandienst — Wed, 09 Jan 2019 09:56:41 GMT

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.

Re: Error in Expression - Duplicate Values

Donicc — Thu, 10 Jan 2019 21:04:25 GMT

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.