topic Re: chart and table not showing same data in QlikView

chart and table not showing same data

Mon, 03 Aug 2015 15:21:38 GMT

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

Re: chart and table not showing same data

Mon, 03 Aug 2015 15:23:00 GMT

attachment !

Re: chart and table not showing same data

marcus_sommer — Mon, 03 Aug 2015 15:24:24 GMT

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

Re: chart and table not showing same data

Mon, 03 Aug 2015 15:28:13 GMT

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.

Re: chart and table not showing same data

marcus_sommer — Tue, 04 Aug 2015 08:27:46 GMT

table and chart not showing same data

Re: chart and table not showing same data

Tue, 04 Aug 2015 08:30:30 GMT

Hi Marcus,

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

Re: chart and table not showing same data

qlikmsg4u — Tue, 04 Aug 2015 08:32:53 GMT

what is your expectation?

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

Re: chart and table not showing same data

Tue, 04 Aug 2015 08:34:47 GMT

Hi, It is now showing same as in table.

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

Re: chart and table not showing same data

marcus_sommer — Tue, 04 Aug 2015 08:35:36 GMT

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

Re: chart and table not showing same data

marcus_sommer — Tue, 04 Aug 2015 08:48:24 GMT

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

Re: chart and table not showing same data

mohammadkhatimi — Tue, 04 Aug 2015 09:47:46 GMT

See the below screenshot..the UID 2372 for 1/1/2015, the sum of table box is 194841.6957 and in Pivot Chart it is 389683.391412, this differ because each number is repeated twice as you can see in the list box with frequency of 2. So in the Chart is showing the sum of all nos twice and table box is showing the distinct values sum.

Hope it helps you!!!

Regards,

Mohammad

Re: chart and table not showing same data

Tue, 04 Aug 2015 10:06:35 GMT

Hi,

You are correct. How will I remove duplicates from chart calculation as I need to use chart only.

Re: chart and table not showing same data

mohammadkhatimi — Tue, 04 Aug 2015 10:10:18 GMT

what do u mean to say u want sum as table Box or Chart??

Re: chart and table not showing same data

Tue, 04 Aug 2015 10:12:11 GMT

as chart .

Re: chart and table not showing same data

mohammadkhatimi — Tue, 04 Aug 2015 10:15:19 GMT

I asked u about the sum..can u please explain me clearly

Re: chart and table not showing same data

Tue, 04 Aug 2015 10:17:13 GMT

I want sum(epmplannedcost) in chart to be same as table box sum.

Table box sum is correct in reality. So chart's sum should also give same.

Re: chart and table not showing same data

marcus_sommer — Tue, 04 Aug 2015 10:21:11 GMT

The chart-calculation itself is correct and also shows the tablebox correct data. Removing from data maybe per distinct while the loads migt lead to incorrect results. I think you need at first to understand your data-source better before goes further. The above mentioned blog-posting to counters within the load is very helpful to understand the data-sources.

- Marcus

Re: chart and table not showing same data

mohammadkhatimi — Tue, 04 Aug 2015 10:22:06 GMT

Try This..

=sum(aggr(sum(distinct EPMPlannedCost),UID,BillingDate))

Regards,

Mohammad

Re: chart and table not showing same data

Tue, 04 Aug 2015 10:49:11 GMT

Hi,

I checked from data source and sum from table object is coming correct but not from chart object

Re: chart and table not showing same data

mohammadkhatimi — Tue, 04 Aug 2015 11:13:21 GMT

Have u check diz....it will work...

Try This..

=sum(aggr(sum(distinct EPMPlannedCost),UID,BillingDate))

Regards,

Mohammad