Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

If(isnull( ClassCd

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'

1 Solution

Accepted Solutions
MVP
MVP

Re: If(isnull( ClassCd

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'))))

2 Replies
MVP
MVP

Re: If(isnull( ClassCd

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'))))

Not applicable

Re: If(isnull( ClassCd

Great, thank you.

This will be added into my Qlik book of knowledge