Removing duplicates

Anonymous — Wed, 18 Apr 2018 01:08:38 GMT

Hi community!

I'm a very new user to Qlik and have created a basic straight table with dimensions below:

SG.Manufacturer Number

SP.Manufacturer Number

SP.Code

PR.Code

PR.Benefit

My Expressions are:

=Sum(If(Match(SGN.MANUFACTURER_NUMBER,SP.MANUFACTURER_NUMBER),1,0))

=Sum(If(Match(SP.Code,PR.Code),1,0))

I want the table to ONLY show me values highlighted in yellow below. This shows that when the Manufacturer Number matches, it would show a 1 (column 3) and if the Manufacture Number's corresponding SP.Code matches PR.Code (Column 5) it would also show a 1 (column 7), which then gives the PR.Benefit (column 6).

How do I remove the duplicates lines that are not matching with 1s (all those lines that are not in yellow)? Would I use an expression in the dimension?

AF-DC-1	AF-DC-1	1	ER199	ER198	1029	0
AF-DC-1	AF-DC-1	1	ER199	ER199	1372	1
AF-DC-1	AF-DC-1	1	ER199	MC821	1285	0
AF-DC-1	AF-DC-1	1	ER199	MI057	194	0
AF-DC-1	BR125-400	0	ER198	ER198	1029	1
AF-DC-1	9402504	0	MC821	MC821	1285	2
AF-DC-1	3120314	0	MI057	MI057	194	1
AF-DC-1	9402508	0	MC821	MC821	1285	2

Can anyone help me?

Thanks in advance,

Re: Removing duplicates

sunny_talwar — Wed, 18 Apr 2018 11:51:10 GMT

May be a condition like this

If(SG.Manufacturer Number = SP.Manufacturer Number and SP.Code = PR.Code, Expression1)

If(SG.Manufacturer Number = SP.Manufacturer Number and SP.Code = PR.Code, Expression2)

Re: Removing duplicates

Anonymous — Wed, 25 Apr 2018 22:49:12 GMT

Thank you! Looks like its working

topic Re: Removing duplicates in QlikView

Removing duplicates

Re: Removing duplicates

Re: Removing duplicates