Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Sunny
The second suggestion worked well. What could be the issue in the database?
I think there are hidden characters which QlikView isn't able to show. We are using * as any wildcard character.
Thank you once again