Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
ashokunbi
Contributor III
Contributor III

Straight table displaying null values

I have a straight table that I don't want displaying null values.  I read a comment that said I can control the value I don't want displayed by making the dimension suppress null values and make expression values I don't want as null values so I have the expression below:

If(1-MAPE >.70,null(), 1-MAPE)

The column is displaying values less than 70% and setting values higher than 70% as null, -, but I don't want it to display the null values period.  Please help.