topic Re: Duplicated row in pivot table in QlikView

Duplicated row in pivot table

zied_ahmed1 — Tue, 30 Jan 2018 10:59:37 GMT

Hello,

I would like to remove the field with - in Nom fourniss and kept the other.the problem if i i do delete null values i will remove the first row who is not duplicated

How to do it...

Thank you

Re: Duplicated row in pivot table

zied_ahmed1 — Tue, 30 Jan 2018 13:41:51 GMT

omarbensalem‌

Re: Duplicated row in pivot table

OmarBenSalem — Tue, 30 Jan 2018 13:57:49 GMT

add a new measure as follow:

count(total <NumFournisseur> NomFournisseur)

u'll have normally, lines where u have only 1 NomFournisseur and others (the one u want to remove) wwith more than one NomFournisseur.

try, and tell me if it's the case?

Re: Duplicated row in pivot table

zied_ahmed1 — Tue, 30 Jan 2018 14:08:40 GMT

Re: Duplicated row in pivot table

OmarBenSalem — Tue, 30 Jan 2018 14:19:26 GMT

can u please show me the repo line where there was a duplication?

Re: Duplicated row in pivot table

stabben23 — Tue, 30 Jan 2018 14:36:50 GMT

Hi,

it looks like you have concatenate two or more datasets.

In Your table, ill think you use one or more Field as dimension which is not concatenated, i.e common keys.

Re: Duplicated row in pivot table

OmarBenSalem — Tue, 30 Jan 2018 14:56:22 GMT

Zied, try to adapt this logic to ur need:

Let's assume I have this :

Related to ur case; we should elminate the duplication in the num=1 since it has 2 names:

to do so; instead of this num dimension, create it as a MEASURE like this:

aggr(only({<num={"=isnull(aggr(count(nom),num))<>-1"}>} num),num)

result:

We'll then need only to uncheck show null values for the new NewNum measure and the duplication is elimnated;