topic Re: Duplicates in Dashboard after Binary Load in QlikView

Duplicates in Dashboard after Binary Load

Anonymous — Mon, 16 May 2016 08:55:02 GMT

Hi All,

No Duplicates in Data model Getting Duplicates in Dashboard after binary load.

Anyone faced the same issue, any help will be appreciated.

Thanks

Neetha

Re: Duplicates in Dashboard after Binary Load

swuehl — Mon, 16 May 2016 08:57:54 GMT

Are you executing any other script statements (LOADs) after the binary statement?

And have you checked that not your chart expressions are duplicating values (for example by using implicite joins, e.g. using data islands)?

Re: Duplicates in Dashboard after Binary Load

avinashelite — Mon, 16 May 2016 09:03:53 GMT

Are you loading any other tables after the Binary load ?? because if the table have similar columns then it will be auto concat ....check the script once or comment script line after the binary load and check for the duplicates records

Re: Duplicates in Dashboard after Binary Load

Anonymous — Mon, 16 May 2016 10:30:34 GMT

Hi All,

thanks for quick response.

Just using inner join to reduce data for particular business area.

Resolved the issue by applying the required filters.

Thanks

Neetha