delete duplicated rows

[zied_ahmed1]

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‌

[OmarBenSalem]

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;

[zied_ahmed1]

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 <> ' '

[sarafamiglietti]

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

[zied_ahmed1]

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

omarbensalem‌ stalwar1‌

[sarafamiglietti]

Hello,

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

[OmarBenSalem]

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

[zied_ahmed1 · Accepted solution]

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)