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?
Solved! Go to Solution.
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.
suppress missing and supress zero are already choose
=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())
this is not a set analysis, you use here If statment and then you need to supress zero values as Prashant says.
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
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.
To avoid to show "outside" Expression you need to use set analysis in the Expressions.
are you using a straight or pivot table?