Why are dimension show date but there not value in expression

[#1]

Hello

I have question about set analysis.

I have date as dimension and I have limit the date in set analysis in expression. The expression do not show any value

(show “-“) when is outside the range of date. The dimension show some rows that is older and younger then the range. 

 

Can some explain the reason of this?

Is there any solution to remove this rows?

Kent Vahlén

[stabben23]

Hi Kent,

if you haver made a "Perfect" set analysis which should show date from mar16-jan17 you will not see the other.

Is Registrerad_Datum inside Your set analysis?

Do you have same set analysis on all 3 Expressions, its a must.

[PrashantSangle]

Hi,

try

suppress missing and supress zero values in presentation tab.

what is your expression??

Regards,

[#4]

Hi Staffan

Yes Registrerad_Datum is in all Set analysis

Yes same set analysis all 3 Expressions

Kent

[#5]

Hello

suppress missing and supress zero are already choose

Expression

=IF(Date(Date#(MonthEnd(Registrerad_Datum_Felhantering_MonthYear),'YYYY-MM-DD')) >= MTBF_Start and  Date(Date#(MonthEnd(Registrerad_Datum_Felhantering_MonthYear),'YYYY-MM-DD')) <= MTBF_End ,(Date(Date#(MonthEnd(Registrerad_Datum_Felhantering_MonthYear),'YYYY-MM-DD')) - Date(Date#(MTBF_Start_Year &  MTBF_Start_Month &  MTBF_Start_Day,'YYYYMMMDD')))*24 * (Count(DISTINCT EQUIPMENT_NAME)) /rangesum(above(count(DISTINCT Arendenr_Felhantering),0,RowNo(TOTAL))), null())

Kent

[stabben23]

Ok Kent,

this is not a set analysis, you use here If statment and then you need to supress zero values as Prashant says.

[#7]

First of all I have already set supress zero

You say I cannot use if statement in that only add that limit inside the  “set Analysis expression”. I need to change the expression

Kent

[PrashantSangle]

Hi,

can you post sample app???

Is your dimension is conditional dimension?? if yes, then move it into script.

also try after removing null() from your expression.

Regards,

[stabben23]

To avoid to show "outside" Expression you need to use set analysis in the Expressions.

are you using a straight or pivot table?

[#10]

I am using straight

Kent