topic Re: Set analysis: sum doubles value in QlikView

Set analysis: sum doubles value

Thu, 25 Apr 2013 06:06:08 GMT

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)

Re: Set analysis: sum doubles value

nilesh_gangurde — Thu, 25 Apr 2013 06:38:48 GMT

Hii pimhof,

Check the flag value for the mismatch data.

-Nilesh

Re: Set analysis: sum doubles value

Thu, 25 Apr 2013 06:49:48 GMT

Hi Nilesh

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

Re: Set analysis: sum doubles value

nilesh_gangurde — Thu, 25 Apr 2013 06:53:04 GMT

If possible please attach the sample data.

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

-Nilesh

Re: Set analysis: sum doubles value

sujeetsingh — Thu, 25 Apr 2013 06:53:49 GMT

Hi Pim ,

Please give a sample or explain in details about functionality.

Re: Set analysis: sum doubles value

Thu, 25 Apr 2013 07:37:19 GMT

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

Re: Set analysis: sum doubles value

er_mohit — Thu, 25 Apr 2013 07:42:14 GMT

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

Re: Set analysis: sum doubles value

Thu, 25 Apr 2013 09:24:47 GMT

Hi er

distinct solves the double summing

unfortunately all the rest of the calculation then is wrong.