Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Date Dimension

I have a Date Dimension that pulls dates within last 60 days:

if(floor([completed_date.autoCalendar.Date])>=(today())-60, completed_date )

Only problem I have is that when this dimension is used in a graph, there is no ability to zoom-in unlike other date dimensions that I have used previously.

"Date([completed_date])"  leads to same error but not limited to 60 days, while just "completed_date" allows me to zoom in.  Any help to solve this small issue is appreciated.

2 Replies
Partner
Partner

try

if(floor([completed_date.autoCalendar.Date])>=DATE((today())-60), completed_date )

Contributor III
Contributor III

Expression works, but same error as previous, no ability to zoom in to graph to narrow view.  Thanks though