chart and table not showing same data

[#1]

Hi,

  I created one table and one chart for sum. but table is showing correct figures but chart's sum is not showing same as table sum. for table sum, I took export to excel and made sum. both are not same.

Reason ?

Thanks

Amit

[#2]

attachment !

[marcus_sommer]

I think you will need to provide more informations with some screenshots, which expressions and dimensions are used and which result will be correct.

- Marcus

[#4]

Hi,

you are right.

I am calculating sum of EPMPlannedCost column in chart with caption cost analysis.

and in table I exported into excel and took sum of same column epmplannedcost

but both sum are not same.

[marcus_sommer]

table and chart not showing same data

[#6]

Hi Marcus,

That query is unanswered. What is use if that link.

[qlikmsg4u]

what is your expectation?

it is showing same sum in text object and pivot chart, except rounding the number

[#8]

Hi, It is now showing same as in table.

from table object, export to excel and check sum for 2372 uid. Its not same.

[marcus_sommer]

The use is to show others that this posting is a double-posting and to prevent that efforts to help would be wasted.

[marcus_sommer]

The reason of these differences is that you used a tablebox which will only show unique combinations of data and duplicates will be ignored. To make sure that you looked on real data-records within such box you need to include an unique id, mostly reach per rowno(), see for this also: Counters in the Load.

- Marcus