Exculding particular values of a field for particular values from a different field

[Qliksense_User]

Hi have 2 dimensions, Segment Code and Subjob No.

I do not want to show Subjob No '0' for  Segment Code '12' and '13'.

Please help..Thanx in advance

[Qliksense_User · Accepted solution]

I got it.

if([OS SEGMENT CODE]='12', if(not(WildMatch(SUBJOB_NO,'0')),SUBJOB_NO),
if([OS SEGMENT CODE]='13', if(not(WildMatch(SUBJOB_NO,'0')),SUBJOB_NO),
SUBJOB_NO))

Thanx.