Problem with Sum aggregate Function in Chart type Pivot table

[#1]

Dear All,

When I am using sum aggregate function in chart type Pivot table in expressions then .

1. It is showing double value without this function it is showing actual value.

1. It is showing allactual no. of rows  without this function it is not showing some rows.

Please  Help.

Thanks In Advance.

[IAMDV · Accepted solution]

Hi Anil,

Just adding some more details on how it works within QV Engine.

Each different data element value of each data element type is assigned a binary code and the data records are stored in binary-coded form. By using the binary coding, QV searches very rapdly on the tables. Morever, redundant information can be removed, resulting in a reduced amount of data. When the user has selects any data element, the binary-coded data records are examined in order to find all data element values implied by the selection.

I hope now you understand the concept of having distinct values.

Also, as mentioned by Sridhar...please use the RowNo() function in the load script to see all the values. By adding the RowNo() function in the load script QV creates a unique record and you can use the same RowNo() field in the Table Box.

Cheers- DV

[#3]

hi D V,

again thanks for reply. yes you right it is showing every row double. it means problem in my data loading script / SQL  View.

Thanks & Regards.

Anil

[#4]

Hi, Sridhar

Thanks for your Quick reply.

Regards

Anil

[#5]

Thanks to all, who's reply me very fast

DV, Sridhar, Anand, Sunil Chauhan

Again Thanks

with Regards.

Anil