topic Re: how to ignore duplicated rows in QlikView

how to ignore duplicated rows

zied_ahmed1 — Mon, 29 Jan 2018 10:00:57 GMT

Hello..

I have this pivot table and i would like when the row have code fournisseur = 0 and the Nom Fournisseur = ' - ' disappear because it's the wrong duplicate row

Thanks for help

Re: how to ignore duplicated rows

zhadrakas — Mon, 29 Jan 2018 10:02:40 GMT

go to Dimension tab on "Nom F..." and tick "Suppress when Value is null"

Re: how to ignore duplicated rows

zied_ahmed1 — Mon, 29 Jan 2018 10:09:23 GMT

I need to keep Nom F.. = ' - ' when the code Four <> 0 so i need to do a condition for them together

Re: how to ignore duplicated rows

zhadrakas — Mon, 29 Jan 2018 10:13:12 GMT

then try dynamic Dimension for Nom F

=if(code Four <> 0 AND len(trim(Nom F))=0, ' ', Nom F)

and tick "Supress when value is null"

Re: how to ignore duplicated rows

prieper — Mon, 29 Jan 2018 10:18:34 GMT

You may choose under dimension to show all value and under Presentation not to display missing or NULL-values

Re: how to ignore duplicated rows

PrashantSangle — Mon, 29 Jan 2018 10:22:04 GMT

How many expression do you have??

In all expression try if condition like

if(code fournisseur<>0,YourExpression)

You can modify it in set anlysis.

sum({<[code fournisseur]-={0}>}Sales)

Regards,

Re: how to ignore duplicated rows

zied_ahmed1 — Tue, 30 Jan 2018 13:01:32 GMT

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