Set analysis: sum doubles value

[#1]

I have a pivot table and for this one address and 2 products it doubles the values. All the other numbers are summed up correctly.

I drilled down to the invoice position - the amount is the amount that is in the position and with this drill-down sum (Stk 2013) and Amount should be equal.

This is the formula I use

Sum({<Kalender.Jahr = {$(vCurrentYear)}>} RechnungsPos.Amount * Flag)

[nilesh_gangurde]

Hii pimhof,

Check the flag value for the mismatch data.

-Nilesh

[#3]

Hi Nilesh

Thanks, but also without the flag the amount is doubled. it doubles the value even when the formula is sum(amount)

[nilesh_gangurde]

If possible please attach the sample data.

Idealy this should not happen. check the base data properly.

-Nilesh

[sujeetsingh]

Hi Pim ,

Please give a sample or explain in details about functionality.

[#6]

Hi  Son

The application should show the amount of sold products per region (drill down country) for the current year.

We have several product lines and for all of them but 2 (and only for one address) it works fine.

according to the invoice addresses and the sold articles I create a pivot table, summing sold products per country. and only for Germany this one address is corrupted and I don't know why/where.

What sort of sample are you looking for? (apologize my question, I am fairly new to QlikView)

Cheers

Petra

[er_mohit]

Sum({<Kalender.Jahr = {$(vCurrentYear)}>}distinct  RechnungsPos.Amount * Flag)

[#8]

Hi er

distinct solves the double summing

unfortunately all the rest of the calculation then is wrong.