Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Removing duplicates

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-1AF-DC-11ER199ER19810290
AF-DC-1AF-DC-11ER199ER19913721
AF-DC-1AF-DC-11ER199MC82112850
AF-DC-1AF-DC-11ER199MI0571940
AF-DC-1BR125-4000ER198ER19810291
AF-DC-194025040MC821MC82112852
AF-DC-131203140MI057MI0571941
AF-DC-194025080MC821MC82112852

Can anyone help me?

Thanks in advance,

 

2 Replies
sunny_talwar

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)

Anonymous
Not applicable
Author

Thank you! Looks like its working