Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ashokunbi
New 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.

8 Replies
Not applicable

Re: Straight table displaying null values

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

ashokunbi
New Contributor III

Re: Straight table displaying null values

I tried that but it didn't work.  It still did not exclude the -1 values.

Not applicable

Re: Straight table displaying null values

Could you share some prints of your sheet?

ashokunbi
New Contributor III

Re: Straight table displaying null values

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.

Not applicable

Re: Straight table displaying null values

Sorry, but are you using Qlik View?

ashokunbi
New Contributor III

Re: Straight table displaying null values

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.

Not applicable

Re: Straight table displaying null values

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 : )

ashokunbi
New Contributor III

Re: Straight table displaying null values

Thanks. I really appreciate your input.