Remove - in expression

[#1]

Hi

The following is from a hierarchy.  I have added a drop list object to my app and have created concatenate expression on the LocalServiceLine and Specialty field.  However, I do not want to include any specialty with '-'.  How can i do this.

[ashfaq_haseeb]

Hi

Try this in backend.

Load *

From table where len(speciality)>0;

Regards

ASHFAQ

[#3]

Hi

I need to include that that as its using the hierarchy method. 

[vardhancse]

So you are trying to exclude null values is that correct ?

[#5]

yeas in this example

[ali_hijazi]

in your expression in set analysis use {<Specialty = {"*"}>}

[vardhancse]

Then once can try in chart properties->Dimensions<tab>->select the required dimension->Suppress when value is null

[#8]

I am using a list box object so no option for that.

[alkesh_sharma]

Use where expression during load.

Where Specialty <> '';

[#10]

Like I said I do not want to loose the null in the load script. How can i do this in the expression in the object.  My expression in the list object is: = LocalServiceLine & ': ' & Specialty