for my oppinion it doesn't depend on the field "FV_GROUP", better take a look at "FORMID":
IF([FORM TYPE]='HCFA 1450' AND LOS >=1,'IH',
IF([FORM TYPE]='HCFA 1450' AND LOS =' ','OH',
If([FORM TYPE]='HCFA 1500','P',
If([FORM TYPE]='NARRATIVE',' ','N')))) AS FORMID,
Check the values of your field FORMID. I am sure you won't find "IP".
You are correct, I made a mistake. I changed the FORMID to IH. I suspect that the IF statement for the FV_GROUP is not right.
I just want to check the TAX ID. If TAX ID = '~' then I want the FV_GROUP to be 'NFV'. If the TAX ID is anything else then I want FV_GROUP to be 'FV'
There are only 6 TAX ID. They are as follow:
Once the FV_GROUP is created then I want to use it an an expression in a chart to show total for each FV_GROUP. I hope this makes sense.
I tested your exam data and QV worked fine (as I expected). see attached qvw
Seems you have some trouble with your data quality within the "TAX ID"-field. I would check for leading / trailing blanks of the "~" because you are filtering on an exact text-string (this is "~" and not for ex. " ~").
If you found it out, possible workarounds may be using Trim(TAX_ID) or Wildmatch(... '*~*')
124036.if not working.qvw 118.2 K