topic grouped codes - QV creating duplicates in QlikView

grouped codes - QV creating duplicates

Thu, 03 Nov 2011 09:33:44 GMT

I have grouped codes on my QV document. They are product & ' - ' & product_dsc. And two other grouped codes. On these grouped codes there are duplicates being created.

For instance, I have 2 entries with 1 number concatenated with a description and another entry underneath with the number and no description. Ive attached my document, can anyone tell me what is going wrong? Thanks very much in advance

grouped codes - QV creating duplicates

Thu, 03 Nov 2011 11:07:51 GMT

I think if you resolve the synthetic table, it should get resolved. You have "MATERIAL" and "MATL_GROUP" in "COPA" and "material" table.

Regards,

Sajeevan

grouped codes - QV creating duplicates

Thu, 03 Nov 2011 16:42:53 GMT

Thanks for the reply, there's definitely problems with tables. Prob Hier seems to be in there on a number of occasions.

Each listbox should be linking up with one another also. I'll definitely have to re-consider the structure

grouped codes - QV creating duplicates

Thu, 03 Nov 2011 18:25:27 GMT

Thanks for the help. I moved the concatenated tables and hung them from the main table, this fixed the issue with my relationships.

grouped codes - QV creating duplicates

rrsrini2907 — Thu, 03 Nov 2011 18:30:56 GMT

Hi still if you want to create the same way as you did previously, you can try this code.

IF(Not IsNull(material_group_description),MATL_GROUP) & IF(Not IsNull(material_group_description),' - ' & material_group_description) as GB

Basically testing not null and concatenating.

Regards,

Srini.