Businesses operate over time, with relevant increments running from one second to a year. In this video, learn how to represent time-based data in Qlik Sense by creating a line chart.
- [Narrator] Businesses collect data over time with relevant increments running from one second to one year or even longer. In this movie, I will show you how to represent time-based data in ClixSense by creating a line chart. I have created a ClixSense app based on the All Details sample file that you can find in the exercise files folder. I have created a new sheet and from the assets panel I can create a line chart by dragging the line chart object onto the body of the sheet.
And, I'll drag it here so it takes up most of the horizontal space along the top and there I have it. Now, I can add at least one dimension and one measure. Because I am dealing with time based data, I will click Add dimension and from the list of fields that appears I will click YearQuarter. Notice that you have YearMonth which would break the data down even further. Then you have Year, which would just have the two years that I have in my data set.
WeeksAgo, WeeksRelative, MonthsAgo, Month, and so on. But in this case, I'll keep it simple and just do Year and Quarter combined. And that's built in. If you provide dates, such as January 1st, 2019, then ClixSense knows how to calculate year and quarter out of that. So that's the dimension. Now I'll click Add measure. And we'll do Total Sales. So, I'll scroll down and my field for that is Order Total so I'll click there and I want to find the sum for each quarter within my years.
So, I'll click Sum and my chart is filled out. If I wanted to, I could change the measure. For example, I could change the operation by click Sum and going to Count, which would give me the count of orders. And I can make other changes to the data if I want. I can also change the data's appearance. So, if I go into the properties panel and click the Appearance header, I get a number of options and they're more than average for a line chart.
Under General, I can show titles, which I usually leave on. I can have a title for the graph which is Quarterly Sales, and you can see that appears at the top. I can also change the presentation. I can make it a line chart or an area chart. An area chart shows the distance between the line and the x-axis as filled. So you can see that here. I tend to prefer line for this type of data so I'll go ahead and click the line sub-type.
You can determine how to handle missing values, showing individual data points, if you like, and also change spacing. To change the colors, you can stay with the auto colors or if you turn that off, you can go from a single color to going by measure or by expression. In this case it would be the same because we only have one. And to change the color, for example from blue you can go to black so it stands out a little bit more against the background. To change the x-axis, go ahead and click that.
And you can have continuous data, which in this case we want because it's not broken down into discreet units and you can also determine whether or not to show the mini chart that appears here at the bottom. If you want to turn the mini chart off, just clear the Show Mini Chart checkbox and you'll just get the main chart by itself. And, you can also control labels and title and the position of the title, if you want it. Finally, on the y or vertical axis, if I click that and scroll down, you see that you can have it on the left, you can change it's scale, or if you want, you can change it's range.
So, for example, you can have the minimum, be it zero, or if you want, you can change the minimum in this case to 20 and enter and you see how your chart moves around based on those values. And finally, if you're dealing with scientific data that's either very large or very small, that could be distances in nanometers, or perhaps interstellar distances, you can use the logarithmic scale. In most cases for business data, though, your data will be perfectly fine using the built-in linear scale.
- Navigating the Qlik Sense user interface
- Managing data sources and tables
- Creating an app from a data source
- Managing Qlik Sense sheets
- Exporting Qlik Sense data to Excel
- Creating bar, line, pie, and scatter plot charts
- Creating charts, text, and images for dashboards
- Creating and manipulating PivotTables
- Sorting and filtering chart and table data