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  

[senpradip007]

Most welcome...

[anbu1984]

From "QV 11 for Developers" Book

A word on calculated dimensions

As useful as they are, calculated dimensions (such as the one we created earlier) are

not performance-friendly. Besides delaying calculation time, they can sometimes

prevent a chart's state from being cached to RAM, hence stopping QlikView's

caching algorithm from coming into play.

As calculated dimensions are sometimes necessary for advanced aggregations, it

is advisable to use this feature only when there is no other way of accomplishing

certain visualizations. Whenever a calculated dimension can be created as a new

field from the script, it is advisable to do so in order to use it in a more natural way

in chart objects

[#4]

Hi Anbu,

Thanks for advise.

I have more than 25 metrics in my report so better i would go calculated dimension.

But I really learned from =If(Not(IsNull(MaxStr)),sum(Target)) your expression as i don't know before that we could use expression label for another expression. 

Best

Robert