Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

expression shows invalid Dimension

Hi,

I'm trying to  show the dates from a column which are between the max and min of other column and when I use below expression it shows invalid dimension. can any one help me resolve the error.

=if(CalendarDate<=max([RDueDate ]) and CalendarDate>=min({<Timestamp=,Timestamp={"$(V_MaxlastMonth)"}>}[RDueDate ]) ,CalendarDate)

Regards,

Harish

 

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Highlighted

Are you using this as a dimension or measure? If this is a dimension, then try this

=If(CalendarDate <= Max(TOTAL [RDueDate ]) and CalendarDate >= Min(TOTAL {<Timestamp = {"$(V_MaxlastMonth)"}>} [RDueDate ]), CalendarDate)

View solution in original post

3 Replies
Highlighted

Are you using this as a dimension or measure? If this is a dimension, then try this

=If(CalendarDate <= Max(TOTAL [RDueDate ]) and CalendarDate >= Min(TOTAL {<Timestamp = {"$(V_MaxlastMonth)"}>} [RDueDate ]), CalendarDate)

View solution in original post

Highlighted
Contributor II
Contributor II

Hi Sunny,

Thanks, it is working. can you say why the below expression is showing invalid? can you please help me fix this.

=date(MonthStart(only( {<Timestamp=,Timestamp = {"$(V_MaxlastMonth)"}[RdueDate]),'MMM-YYYY')

I want to exclude the filter for the Timestamp field.

Also, can you say why below expression is returning blank

  Min( {1<Timestamp=,Timestamp = {"$(V_MaxlastMonth)"}>} [RdueDate] )

Thanks in advance.

Highlighted

I think the expression is not correct syntax wise... try this

=Date(MonthStart(Only({<Timestamp=, Timestamp = {"$(V_MaxlastMonth)"}>} [RdueDate])), 'MMM-YYYY')

Also, why are you using Timestamp twice in your expression? Only the second one will actually work... so, may be just use this

=Date(MonthStart(Only({<Timestamp = {"$(V_MaxlastMonth)"}>} [RdueDate])), 'MMM-YYYY')

Not really sure about this one

Min({1<Timestamp=, Timestamp = {"$(V_MaxlastMonth)"}>} [RdueDate])

May be this

Min({1<Timestamp = {"$(V_MaxlastMonth)"}>} [RdueDate])