12 Replies Latest reply: Mar 15, 2017 5:24 AM by Kent Vahlen

# Why are dimension show date but there not value in expression

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

• ###### Re: Why are dimension show date but there not value in expression

Hi Kent,

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

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

• ###### Re: Why are dimension show date but there not value in expression

Hi Staffan

Yes Registrerad_Datum is in all Set analysis

Yes same set analysis all 3 Expressions

Kent

• ###### Re: Why are dimension show date but there not value in expression

Hi,

try

suppress missing and supress zero values in presentation tab.

Regards,

• ###### Re: Why are dimension show date but there not value in expression

Hello

suppress missing and supress zero are already choose

Expression

Kent

• ###### Re: Why are dimension show date but there not value in expression

Ok Kent,

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

• ###### Re: Why are dimension show date but there not value in expression

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

• ###### Re: Why are dimension show date but there not value in expression

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

are you using a straight or pivot table?

• ###### Re: Why are dimension show date but there not value in expression

I am using straight

Kent

• ###### Re: Why are dimension show date but there not value in expression

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,

• ###### Re: Why are dimension show date but there not value in expression

Hi

It is not a conditional dimension is a value from  source

Kent

• ###### Re: Why are dimension show date but there not value in expression

If you untick "Enable" on Your Expressions one by one, is it one of the Expression that force the "outside" Dimension?

Or does all expression one by one shows the unexpected values in Dimension?

• ###### Re: Why are dimension show date but there not value in expression

You are right in you assumation i need to limit inside the set analysis  that make extra rows go away.

Kent