Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
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,
Estela
I tried that but it didn't work. It still did not exclude the -1 values.
Could you share some prints of your sheet?
Here you go. It’s supposed to only show FCA <= 70%. Where you see the – is where they are over 70%. Thanks for your response.
Sorry, but are you using Qlik View?
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 : )
Thanks. I really appreciate your input.