Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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'))))
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'))))
Great, thank you.
This will be added into my Qlik book of knowledge