topic Re: Error In Summission of data in QlikView

Error In Summission of data

Mon, 17 Dec 2012 11:09:52 GMT

Hi,

I have a table with following load script:-

Table

Load

subject,

marks

from table_name;

While using sum for this table, the total summission comes as double:

Total

Load

'Total' as [Total]

sum(marks)

resident Table;

ex:-

CHE 10

Math 10

Fetching data from total table:-

Total 40

Is there any problem with load script or any unidentified loop works. Need help.

Thanks for help...

Mon, 17 Dec 2012 11:31:44 GMT

Also, While creating the same table using group by doen't work as I don't need to group the fields , Whole sum is required.

And Load

sum(marks)

resident Table;

provides same output as Total 40

giakoum — Mon, 17 Dec 2012 11:36:34 GMT

Looks like the problem is your data. Could you please provide sample data? QV does not double anything unless it is there ...

Where do you see that 40? In a chart? a sample app would help.

Wed, 19 Dec 2012 05:43:16 GMT

Thanks, its done now.