Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
a_kosarev
Contributor II
Contributor II
‎2020-01-30 02:40 AM

Limit dates in a line chart

I'm trying to exclude the first month data from a line chart and use the expression below: 

=if(Utilization_Date > monthend(min(Utilization_Date)), [Utilization_Date.autoCalendar.YearMonth])

Could anyone tell me why it returns the 'invalid dimension' error? 

 

360 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2020-01-30 02:43 AM

Try below, since Aggregate functions are not allowed without aggregate

=if(Utilization_Date > monthend(Aggr(min(Utilization_Date), Utilization_Date)), [Utilization_Date.autoCalendar.YearMonth])

 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
347 Views
0 Likes