How to remove null() and space in TableBox

[ravikumar_iyana]

Hi,

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

name	student
	John
ravi	Reddy
kumar	Prem
sai	Kumar
anil	runil
teja	mani
shiva	krishna

I am already used this below:Requirement: when  Tab:Teacher is null then all Column will disappear

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

[HirisH_V7]

While loading itself use,

where name<>Null();

[ravikumar_iyana]

Hi Or Shoham,

I am already used Omit null but its not working in tablebox

[ravikumar_iyana]

Hi Hirish,

The two fields of data taking different tables at that time of loading in table box how can i will write this function

[Mark_Little]

It wouldn't look like you want on the chart and i am not 100% sure it would work with out playing.

You might be able to get something that export out to excel as you want and gives you similar functionality.

Add expressions in your chart for you percentages, tick the invisible box and Text as Popup, should see your values on hover and will export to excel.

Mark

[HirisH_V7]

Then that case you can go , i suggest to use straight table for this.

[ravikumar_iyana · Accepted solution]

Hi Or Shoham,

I am tried your expression its working fine but little modification required i don it like this

=if(len(FieldName)>0,FieldName,Null())

Thanks for your valuable response