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.
You could change your expression so instead of displaying 'null', it could display a number, for example '-1'.
Then, you could go to the "Data" tab and select your dimension.
Under "Limits" or "Limitation" label select "Exact Value" and then specify it to show only the values greater than '-1'.
I hope it helps,
Yes. I just sent an Excel copy so you can see the values I’m getting. There is a lot of proprietary data on the page so I couldn’t send a screen shot.
If you are using Qlik View, please refer to the 'New to QlikView. Discussion Forum
This discussion is about Qlik Sense, and since they are quite different, it is better if you use the specific forum.
I suggest you to use sample data to show your sheet, so you don't have to use Excel and can get faster responses.
I hope it helps : )