values are not matching with backend data

[kavitha_kommise]

hello everyone,

i have multiple tables in one file.using db i am loading table into resident tables using SQL query.

in one sheet i am reading data from one of table.just aggregation i am doing.but aggregation is not matching with backend data only for one filed.for remaining i am getting value properly.i could not form whee it is taking............

the same table i have loaded alone in one more file  i am getting values properly.but i am not getting values properly in file which i am loading multiple tables.can anyone help on same.

what could be the reason...? how to fix this issue?

Thanks in advance,

kavitha

[olivierrobin]

hello

you say : when I load single table, the results are ok

with multiple ones, it(s not

that could be a problem of relationship between your tables

check the cardinalities of the relationships (1 to 1, 0 to n, ...)

[kavitha_kommise]

hello,

can u please tell how to check cardinalities.but there is no relation between any table.all are individual tables.

thanks and regads

kavitha

[olivierrobin]

if the tables are not linked together, make sure you don't use columns of two tables

(ex: an axis from one table, and measures from another)

[kavitha_kommise]

hello robin,

issue was in data i have one synthetic key which is having value null so qlikview is not aggregating values which synthetic key having null.

thanks for the support.