topic Re: Data is coming double. in QlikView

Data is coming double.

prma7799 — Fri, 10 Jul 2015 06:08:57 GMT

Hi All,

I am stuck with one issue.

I have State and HQID(HQNAME) with hierarchy there is only one HQ in one state but in my report it is showing me repeat and double value.

PFA.

Thanks

Re: Data is coming double.

PrashantSangle — Fri, 10 Jul 2015 06:32:08 GMT

Hi,

I dont find any duplication

Since highlighted HQ belongs to different State.

REgards

Re: Data is coming double.

Kushal_Chawda — Fri, 10 Jul 2015 06:39:41 GMT

This is not actually duplicates

BHUBNESHWAR POOL is available in two different states (MP, ORISSA)

BAREILLY is available in two different states (UP, UTT)

Please check your POOL mapping with states.

Re: Data is coming double.

prma7799 — Fri, 10 Jul 2015 06:46:12 GMT

Hi kush,

@dreamer4

You are right but in our organization maintain one different web base application for analysis purpose and there BAREILLY is showing in UP state. And we fetch data from there then how in QV it will appear.

Thanks

Re: Data is coming double.

PrashantSangle — Fri, 10 Jul 2015 06:53:23 GMT

Hi,

Value for BHUBNESHWAR POOL in MP having negligible value i.e. -0.002

because of that might be it is not capturing in your web base application or they are considering only + values.

Regards

Re: Data is coming double.

Kushal_Chawda — Fri, 10 Jul 2015 07:02:08 GMT

Hi,

Please share the data which you are fetching from web base application.Otherwise it will be difficult to find where is issue

Re: Data is coming double.

Anonymous — Fri, 10 Jul 2015 11:34:00 GMT

Do your your hierarchy table associated with any other table ??

In that case you need to first load hierarchy table and then define the relation by renaming the column.

It happened when we first associate the table and then load the hierarchy.

Thanks

BKC