Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how to hide this row? I tried using "suppress null values" and "suppress zero" values, but nothing happens. What expression can I write to substitute 0 with null value?
Have you tried 'Suppress When Value is Null' on the dimension tab?
Yes, I've tried that.
One of your expressions fields has data that does not have a corresponding value in your dimension. You can choose to ignore these values by following Sunny's advice or you can try to clean up the data in your source table.
can you post your QVW to fix the issue?
You could try changing your expression to something like If([Your Expression]=0, null(), [Your Expression]) and then checking the "suppress when value is null" option
If your column is a field, then you could make a Where Clause in your script like this:
WHERE [# Targeted POCs] <> 0;
Regards,
MB
Which fields are expressions? and which are dimensions?
If all of them are dimensions you could create one field for expression and set not to show null values.
Giba
DM is the dimension. The rest are expressions.
Brittany,
Please share the expression you are using for # Targeted POC.