topic Re: Supress null values not responding in QlikView

Supress null values not responding

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm not able to suppress the null values even after check the options in dimension and presentation boxes.

Below is my table result..where i need to suppress the null values.

Table used : Straight table.

Thanks.

Re: Supress null values not responding

nagarjuna_kotha — Mon, 03 Oct 2016 09:43:01 GMT

Can u share the snapshot that shows dim and Exp.

As per my understanding , you have more then five exp and in last 4 exp you are getting null and you want to show them , right ?

-Nagarjun

Re: Supress null values not responding

Anil_Babu_Samineni — Mon, 03 Oct 2016 09:46:24 GMT

Better approach if you share the application.

Re: Supress null values not responding

miskin_m — Mon, 03 Oct 2016 09:47:21 GMT

Hi,

I think there might be issue with you expression like it might be dividing the expression by zero. Try to debug the expression and check what values it returns and each individual level, if expression is too complex.

Re: Supress null values not responding

nareshthavidishetty — Mon, 03 Oct 2016 11:22:43 GMT

yes..I need to remove those null values.

Thanks..