Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ravikumar_iyana
Contributor

How to remove null() or empty spaces in Table Box

Hi,

I am facing a problem for removing null() or spaces in tablebox.

Teacherstudent
    John
raviReddy
kumarPrem
saiKumar
anilrunil
tejamani
shivakrishna

Requirement: when  Tab:Teacher is null then all Column will disappear

I am already used this below:

1) I am already used trim() in script level

2) In Table Box -> presentation -> i am checked Omit Rows where field is null

plz help me ASAP

9 Replies
agigliotti
Honored Contributor II

Re: How to remove null() or empty spaces in Table Box

in View or Sense ?

ravikumar_iyana
Contributor

Re: How to remove null() or empty spaces in Table Box

In View

Quy_Nguyen
Contributor III

Re: How to remove null() or empty spaces in Table Box

Hi Ravi,

If you want to treat spaces as null, try this in the script load:

If(Trim(Teacher) = '', Null(), Teacher) As Teacher

Then In Table Box -> presentation ->  check Omit Rows where field is null.

agigliotti
Honored Contributor II

Re: How to remove null() or empty spaces in Table Box

try below in script:

if( len(trim(Teacher))=0, null(), Teacher ) as Teacher

and check Omit rows where field is null.

ravikumar_iyana
Contributor

Re: How to remove null() or empty spaces in Table Box

Hi Andrea,

I am tried that Omit rows

Buts its not working

agigliotti
Honored Contributor II

Re: How to remove null() or empty spaces in Table Box

are you sure the "Teacher" field value for student "John" is blank ?

shraddha_g
Honored Contributor III

Re: How to remove null() or empty spaces in Table Box

is it blank or null?

sureshqv
Esteemed Contributor III

Re: How to remove null() or empty spaces in Table Box

try

If(isnull(Teacher) , Null(), Teacher) As Teacher

saniyask
Contributor

Re: How to remove null() or empty spaces in Table Box

Hi,

hope this helps.

Regards,

Saniya