Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie_To_Qlik
Contributor II
Contributor II

Creating bar chart

Hi, 

I'm creating a bar chart with actual dates and no of activities. Can anyone help to guide me if i can group those dates in terms of month and year (example: group 01 May 2020, 05 May 2020 and 19 May 2020 into May 2020).

My data available is the actual dates.

 

Newbie_To_Qlik_0-1616319299686.png

 

2 Replies
Lisa_P
Employee
Employee

There are a few ways to do it. The best way is to create these extra dimensions in your load script, but if you do not have access to that you can also do it in the sheet view.

Either way you can do the following:

MonthYear can be created by using Monthsstart function to reset the date to the first of the month and then display as Month and Year eg Date(Monthsstart([Schedule Date]), 'MMM YYYY')

Newbie_To_Qlik
Contributor II
Contributor II
Author

Hi Lisa

Thanks for the reply.

I'm very new to Qlik and if you don't mind, can you share more details on how we can do it in the sheet view.

thank you