Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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. 

  fel2.jpg

 

Can some explain the reason of this?

 

Is there any solution to remove this rows?

 

 

Kent Vahlén

 

1 Solution

Accepted Solutions
Not applicable

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

12 Replies
stabben23
Honored Contributor

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.

Is Registrerad_Datum inside Your set analysis?

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,

try

suppress missing and supress zero values in presentation tab.

what is your expression??

Regards,

Regards,
Prashant Sangle
Not applicable

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

Not applicable

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

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_YearMTBF_Start_MonthMTBF_Start_Day,'YYYYMMMDD')))*24 * (Count(DISTINCT EQUIPMENT_NAME)) /rangesum(above(count(DISTINCT Arendenr_Felhantering),0,RowNo(TOTAL))), null())

Kent

stabben23
Honored Contributor

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.

Not applicable

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

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,

Regards,
Prashant Sangle
stabben23
Honored Contributor

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?

Not applicable

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

I am using straight

Kent