Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
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