Data is coming double. - Qlik Community

prma7799 · ‎2015-07-10

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

PrashantSangle · ‎2015-07-10

Hi,

I dont find any duplication

Since highlighted HQ belongs to different State.

REgards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Kushal_Chawda · ‎2015-07-10

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.

prma7799 · ‎2015-07-10

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

PrashantSangle · ‎2015-07-10

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Kushal_Chawda · ‎2015-07-10

Hi,

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

Anonymous · ‎2015-07-10

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