Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
PFA. Hope it will meet your requirement.
Hi,
Use isnull()
like
if(not isnull(Supplier),MaxString(Supplier))
Regards
Robert,
Try to use a calculated dimension:
=if(len(Suplier)>0, Suplier)
and check Supress when value is null.
Marc.
Try something like:
If(Trim(MaxString(Supplier))='',0,MaxString(Supplier))
then check suppress zero value in presentation tab
let me know ...
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.
Check this qvw
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.
PFA. Hope it will meet your requirement.
Check this
Its works.
Thanks everyone....
Many Thanks Mr.Anbu and Mr.Pradip.