Expression

[Anonymous]

What could be wrong with the following expression:

If(Len(Trim([Med Aid])) = 0, 'UNKNOWN', If([Med Aid] = 'PRIVATE', 'OUT-OF-POCKET',[Med Aid])) as [Payment Type]

Regards.

Chris

[Anonymous]

Thanks Dena

The 'UNKNOWN' value is substituted when the [Med Aid] field is NULL or does not contain any values.  The 'OUT-OF-POCKET' value is replacing the [Med Aid] field when the vale is 'PRIVATE'

REGARDS

[Anonymous]

Hi Sunny

The second suggestion worked well.  What could be the issue in the database?

[sunny_talwar]

I think there are hidden characters which QlikView isn't able to show. We are using * as any wildcard character.

[Anonymous]

Thank you once again