If(isnull( ClassCd

[#1]

I have two fields I need to populate ClassCd nulls with MOP

Pivot Table

This part works great.

=If(wildMatch(ClassCd, '01', '04','05'), 'Commercial',   

If(wildMatch(ClassCd, '02'), 'Medicaid',

If(wildMatch(ClassCd, '03'), 'Med D',

If(wildMatch(ClassCd, '06'), 'Hospice',))))

I need to populate the nulls with what is in field MOP

The three nulls needs to roll into two

FACI should be 'Facility'

GUAR , PRIV should be 'Private'

[sunny_talwar · Accepted solution]

May be this

=If(wildMatch(ClassCd, '01', '04','05'), 'Commercial',

If(wildMatch(ClassCd, '02'), 'Medicaid',

If(wildMatch(ClassCd, '03'), 'Med D',

If(wildMatch(ClassCd, '06'), 'Hospice',

If(Match(MOP, 'FACI'), 'Facility', 'Private'))))

[#3]

Great, thank you.

This will be added into my Qlik book of knowledge