I am new to Qlik Sense, and am having trouble grouping dates for a line graph. I have a list of values which each has a date and a revenue. I've created a line graph with these values, but the x-axis shows individual dates (it's through two years) and it's really long. How can I group the dates to make the x-axis shorter? I'd like to have a sum value for each month over those two years. Thanks.
Another alternate you can use is to include a Master Calendar table in the data model, and link it with the revenue date field. Once created, you can show the different revenue dates grouped by quarter, month name, month number, year, etc. A sample script of the Master Calendar can be found in this QlikCommunity post:
But what if you want to show the individual day changes in the line chart, but show only months on the x-axis? For example, the FTSE-100 changes every day, but on the x-axis you want to show Jan, Feb, Mar and on the y-axis the index. I don't want to group it so I get an average for January, I want to see every individual movement but don't want to see every date on the x-axis. How do I do that?