How to suppress the null values in expression level

[#1]

hi

i need to suppress the null values based on expression

Thanks

siddiq    

[sunny_talwar]

Not sure I understand, but may be like this....

If(Len(Trim(Expression)) > 0 , .....)

[#3]

here expression field is depends on start time and end time

for example :

if start time is zero then it should not show in the chart

[sunny_talwar]

I am not still not sure I understand. Would you be able to upload a sample

[#5]

i have the below image in that item number is dimension .start date and end date derived based on expression.here i have to suppress the null values.

For example:in the below chart i should not see itemno 103 and 104,101 because in these we have nulls.i need only one record  i.e item 102 .but we should filter based on expression not based on dimension .

[#6]

Hi

Can you elaborate more whether it is for Straight Table or Pivot Table to suppress the null values at expression level. So that we will help you shortly

Thanks

Reddi Kishor.

[engishfaque]

Dear Abubakar,

Exclude these values by using listed below Set Analysis Modifiers, these modifiers need to be add in your expression

[Start Date] -= {"=Null()"}, [End Date] -= {"Null()"}

Kind regards,

Ishfaque Ahmed

[PrashantSangle]

Hi,

What is your expression???

try like

sum(if(len(trim(startDate))>0,sales))

Kind Regards

[Kushal_Chawda]

=sum({<StartTime ={'*'},EndTime ={'*'}>}Value)

Meaning of * in set analysis is, give all the Values excluding *, Make sure that you have checked the "Suppress Zero Values" in presentation tab

[phaneendra_kunc]

U can do this in two ways.

1. On dimension tab enable SUPRESS NULL VALUES on StartTime and EndTIme fields.

2. add a expression Sum(if(len(StartTime)<>0 and len(EndTime)<>0, METRIC_FIELD))