How to remove null string values in the expression?

[#1]

Hi everyone,

I have created an expression =MaxString(Supplier) in my straight table but some of rows are blank.

If i used Supplier in the Dimension, I could use Suppress when value is Null  option but i want do the same in the expression.

I would be really grateful if you advise me how to fix this issue.

Best

Robert  

[PrashantSangle]

Hi,

Use isnull()

like

if(not isnull(Supplier),MaxString(Supplier))

Regards

[Anonymous]

Robert,

Try to use a calculated dimension:

=if(len(Suplier)>0, Suplier)

and check Supress when value is null.

Marc.

[alexandros17]

Try something like:

If(Trim(MaxString(Supplier))='',0,MaxString(Supplier))

then check suppress zero value in presentation tab

let me know ...

[Gysbert_Wassenaar]

If the values were really nulls then Suppress When Value is Null would suppress them. Nulls cannot be selected, so if you can select such a value you know it's not a real null. You can replace the spaces with something else in the script. You can check for such values with something like if(len(trim(MyField))=0, 'No Value', MyField) as MyField.

[anbu1984]

Check this qvw

[#7]

Hello everyone,

Thanks for your reply.

I just used the Mr.Anbu Sample qvw file, he given my expected answer but now i added one more attribute(Target) in the data and added sum(Target) expression in table then i want to remove the null value of supplier So, i tried your advised way but it doesn't work.

I want to remove the red color marked data and attached the Mr.Anbu qvw file.

[senpradip007 · Accepted solution]

PFA. Hope it will meet your requirement.

[anbu1984]

Check this

[#10]

Its works.

Thanks everyone....

Many Thanks Mr.Anbu and Mr.Pradip.