I would like to display all the fields equal to or that match 'Y' for the projected_order field. Currently I can only identify those matching fields and can not figure out how not to display them in my chart. For example those values whose projected_order = 'N' or null for example I would like them not to display in the chart.
This should be fairly easy but I am missing something. I would like it to function in the same way QV does natively when you select 'Y' for this field.
You're right that the syntax is incorrect. This should be your calculated dimension:
=IF(projected_order= 'Y',projected_order)
You would also need to check the "suppress when value is null" checkbox. This assumes that you have a 1-dimension, 1-expression chart. I don't know what your expression is, but you don't need to check for the value of projected_order in it. If you have a more complex chart, I would recommend using set analysis in the expression and leaving the dimension alone. For example, if your expression is a simple sum(Sales), then the expression would be:
I would say either just create a calculated dimension that uses an IF statement to check whether projected_order = Y. Or use set analysis in your expression to set your project_order to Y.
This marks all projected_orders with 1 but does not remove them. Something is wrong with the syntax. I would remove all but the ones marked with 1 to be removed from the chart.
You're right that the syntax is incorrect. This should be your calculated dimension:
=IF(projected_order= 'Y',projected_order)
You would also need to check the "suppress when value is null" checkbox. This assumes that you have a 1-dimension, 1-expression chart. I don't know what your expression is, but you don't need to check for the value of projected_order in it. If you have a more complex chart, I would recommend using set analysis in the expression and leaving the dimension alone. For example, if your expression is a simple sum(Sales), then the expression would be:
