topic Re: How to remove null() and space in TableBox in QlikView

How to remove null() and space in TableBox

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

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

Re: How to remove null() and space in TableBox

Mark_Little — Tue, 14 Nov 2017 14:25:45 GMT

A quick fix would be a calculated dimension for student.

IF(LEN(TRIM(name)) >0, Student)

if that doesn't work you could add the same to to the name deimension

Mark

Re: How to remove null() and space in TableBox

Anil_Babu_Samineni — Tue, 14 Nov 2017 14:28:16 GMT

1) Have you tried using Len(name) > 0 and Tab = 'Teacher'

2) I believe, In table box there is no future called "Suppress". May be you are using straight table

Re: How to remove null() and space in TableBox

ravikumar_iyana — Tue, 14 Nov 2017 14:29:26 GMT

Hi Mark in listBox we can use like this your expression but now i my requirement is TableBox

Re: How to remove null() and space in TableBox

Anil_Babu_Samineni — Tue, 14 Nov 2017 14:32:27 GMT

May be this?

Only({<Name = {"=Len(Name) > 0"}>} Student)

Re: How to remove null() and space in TableBox

ravikumar_iyana — Tue, 14 Nov 2017 14:32:42 GMT

Hi Anil,

Thanks for u r valuable response my requirement is table box only not for Straight Table

Re: How to remove null() and space in TableBox

Anil_Babu_Samineni — Tue, 14 Nov 2017 14:34:17 GMT

No You can not in table box as we doesn't have futures like straight. But, you can use Straight table as you feel and looks like same.

Re: How to remove null() and space in TableBox

Mark_Little — Tue, 14 Nov 2017 14:36:03 GMT

Hi.

Yer sorry wouldn't work in a table box.

But you could use a straight table, Use the name as your Dimension and the expresssions would be

IF(LEN(TRIM(name)) >0, Student)

Mark

Re: How to remove null() and space in TableBox

Or — Tue, 14 Nov 2017 14:43:52 GMT

Why would you *require* a table box? What does it do that a straight table does not?

You could add secondary fields that are null based on the specific value at the script level, e.g.

Load Student, Name, if(Len(Name)>0, Student) as StudentForTableBox, if(Len(Name)>0,Name) as NameForTableBox;

In that situation I think you should be able to omit nulls from table box, since both fields are null.

Re: How to remove null() and space in TableBox

ravikumar_iyana — Tue, 14 Nov 2017 14:43:57 GMT

Hi Mark,

I am tried this already in straight table also "IF(LEN(TRIM(name)) >0, Student)" its not working

Re: How to remove null() and space in TableBox

HirisH_V7 — Tue, 14 Nov 2017 14:44:52 GMT

While loading itself use,

where name<>Null();

Re: How to remove null() and space in TableBox

ravikumar_iyana — Tue, 14 Nov 2017 14:46:20 GMT

Hi Or Shoham,

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

Re: How to remove null() and space in TableBox

ravikumar_iyana — Tue, 14 Nov 2017 14:48:40 GMT

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

Re: How to remove null() and space in TableBox

Mark_Little — Tue, 14 Nov 2017 14:57:46 GMT

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

Re: How to remove null() and space in TableBox

HirisH_V7 — Tue, 14 Nov 2017 14:58:19 GMT

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

Re: How to remove null() and space in TableBox

ravikumar_iyana — Wed, 15 Nov 2017 03:49:14 GMT

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