topic Re: values are not matching with backend data in QlikView

values are not matching with backend data

kavitha_kommise — Thu, 04 Oct 2018 07:09:32 GMT

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

Re: values are not matching with backend data

olivierrobin — Thu, 04 Oct 2018 08:36:36 GMT

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, ...)

Re: values are not matching with backend data

kavitha_kommise — Thu, 04 Oct 2018 10:32:48 GMT

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

Re: values are not matching with backend data

olivierrobin — Thu, 04 Oct 2018 11:31:25 GMT

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)

Re: values are not matching with backend data

kavitha_kommise — Thu, 04 Oct 2018 11:36:20 GMT

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.