Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi
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
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
Hi Mark in listBox we can use like this your expression but now i my requirement is TableBox
May be this?
Only({<Name = {"=Len(Name) > 0"}>} Student)
Hi Anil,
Thanks for u r valuable response my requirement is table box only not for Straight Table
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.
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
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.
Hi Mark,
I am tried this already in straight table also "IF(LEN(TRIM(name)) >0, Student)" its not working