topic Re: delete duplicated rows in QlikView

delete duplicated rows

zied_ahmed1 — Wed, 31 Jan 2018 13:13:41 GMT

Hello,

I would like to delete duplicated rows but if i tick "Supress when value is null" another not duplicated rows will disappear.

So I need to do this condition :

Code Fourniss = 0

Nom Fourniss = ' - '

Numéro Facture <> '' (<> empty

i share for you my example : (I need to keep the line in blue becasue it's not a duplicated row )

Thanks

omarbensalem‌ stalwar1‌

Re: delete duplicated rows

OmarBenSalem — Wed, 31 Jan 2018 13:27:46 GMT

yesterday's solution did not work ?

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;

Re: delete duplicated rows

zied_ahmed1 — Wed, 31 Jan 2018 13:36:49 GMT

i found a solution for the problem 2 name for one code now i need this condition :

delete rows who have code Fourn = 0 , Nom fournisseur = ' - ' and numéro facture <> ' '

Re: delete duplicated rows

sarafamiglietti — Wed, 31 Jan 2018 13:38:23 GMT

Hello,

Do you have expressions in your table?

If yes, you can add an if condition in all your expressions like :

IF(Code Fourniss <> 0 AND not isnull(Nom Fourniss),tip your formula)

If no, you can add a "fake" expression like:

IF(Code Fourniss <> 0 AND not isnull(Nom Fourniss),1)

And you can mask this column after.

(Sorry, can't help you more without your qlik document or an example)

Regards

Re: delete duplicated rows

zied_ahmed1 — Wed, 31 Jan 2018 15:30:26 GMT

This is the application : please choose Septembre 2017 and Compte = 6061000 to try :

omarbensalem‌ stalwar1‌

Re: delete duplicated rows

sarafamiglietti — Wed, 31 Jan 2018 15:33:25 GMT

Hello,

I can't open the document. I need an User ID...

Re: delete duplicated rows

OmarBenSalem — Wed, 31 Jan 2018 15:37:50 GMT

Sorry, can't open it; don't have QlikView on my machine...

Re: delete duplicated rows

zied_ahmed1 — Wed, 31 Jan 2018 15:39:50 GMT

Hello,

Thank for your time, I found the solution :

in the Measure i do this :

sum({<[Code Fournisseur]={'0'},INVOICE={''}-{' *'}>}ACCOUNTINGCURRENCYAMOUNT)

sum({<[Code Fournisseur]-={'0'}>}ACCOUNTINGCURRENCYAMOUNT)