Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)
Thank you! Looks like its working