topic Re: Getting Duplicate Description in List in QlikView

Getting Duplicate Description in List

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have Fact table is joined with Dim table on two fields. Item_Key and Product Group Major.

Dim_Item has Group Major Description.

If we put in simple List Box. I am getting two valid value for Description.

But if i make a Table Box using same fields, I am getting one extra records against all ProductGoupMajor code.

I am not getting this. How to resolve?

Please help.

Thanks,

Sarif

Re: Getting Duplicate Description in List

PrashantSangle — Wed, 08 Mar 2017 10:19:51 GMT

Hi,

Remove synthetic key by creating composite key.

then add composite key in table box

Using existing data model in your table box add ProductGroupMajor and Item_key Field.

Provide snip after adding above 2 fields.

Regards,

Prashant

Re: Getting Duplicate Description in List

muthukumar77 — Wed, 08 Mar 2017 10:22:26 GMT

May be like this,

Com_fact:

Load

Item_Key & Product Group Major as key,

Item_Key ,

Product Group Major

from Com_Fact;

Dim_Item:

Load

Item_Key & Product Group Major as key,

from Dim_Item;

Re: Getting Duplicate Description in List

mhmmd_srf — Wed, 08 Mar 2017 10:24:55 GMT

Hi Prashant,

Below is the snip after adding Item_Key:

Please help.

Thanks,

Sarif

Re: Getting Duplicate Description in List

PrashantSangle — Wed, 08 Mar 2017 10:29:32 GMT

So you can see due to item key in you synthetic key you are getting 2 Group description..

confirm what is your key on which you need to associate table.

Regards,

Prashant

Re: Getting Duplicate Description in List

mhmmd_srf — Wed, 08 Mar 2017 10:31:31 GMT

If I use composite key it is coming like this:

Please help.

Thanks,

Sarif

Re: Getting Duplicate Description in List

Wed, 08 Mar 2017 10:36:02 GMT

Hi Mohammad,

It is not best idea to use field which acts as a key in table (in your example you are using ProductGroupMajor). And doesn't matter if it is part of synthetic key or not.

In your case as they write before you should first avoid synthetic key by creating new field:

[Item_Key]&'_'&[ProductGroupMajor] as %Key

But of course you should remember to comment or rename fields Item_Key and ProductGroupMajor in one of the tables. And best approach is not to use field %Key in charts or tables.

BR,

Milosz

Re: Getting Duplicate Description in List

mhmmd_srf — Wed, 08 Mar 2017 10:46:00 GMT

No sir,

I do not have any synthetic now. See this

Thanks,

Sarif

Re: Getting Duplicate Description in List

mhmmd_srf — Wed, 08 Mar 2017 11:31:19 GMT

Hi Pranshant,

But using Composite Key also we are not able to resolve the issue.

Please help.

Thanks,

Sarif

Re: Getting Duplicate Description in List

PrashantSangle — Wed, 08 Mar 2017 11:35:07 GMT

Issue is not in key.

Please confirm, Is Item_key is part of Synthetic key.???

If yes then check GroupDescription is available for those combination in your source data.

Regards,

Prashant

Re: Getting Duplicate Description in List

Wed, 08 Mar 2017 11:41:14 GMT

Hi Mohammand,

That is a basic data quality / data modelling problem. You need to think about data in both tables and relation between them. And don't believe in List Boxes because they don't show null values.

Maybe you should double check if you created "ItemGrpMjrKey" correctly (check density and subset ratios for the fields in the data model viewer). It seems that the key is not connecting tables properly.
Or maybe only field "Item_key" will be better to act as key in that case? Probably DIM_ITEM table has got one row per Item or at least it should have.

You need to check that because without seeing qvw file I cannot give you better support.

BR,

Milosz

Re: Getting Duplicate Description in List

sasiparupudi1 — Wed, 08 Mar 2017 12:41:10 GMT

Drop Product Group Major field from the fact table

Re: Getting Duplicate Description in List

sasiparupudi1 — Wed, 08 Mar 2017 12:41:50 GMT

Drop Product Group Major Field from your fact table

hth

Sas