Qlik Sense Tutorials - Creating QlikSense Sheets and Exploring Sheet Options

Qlik Sense Tutorials - Creating QlikSense Sheets and Exploring Sheet Options In this #qlik sense tutorial video I have talked about how you can create new #qliksensesheets and explore its various options that are helpful while setting up a new project and sheet for reporting and #dashboarding. #QlikSenseTutorial Structuring an app using sheets Sheets provide a way of structuring your ideas and purposes for your app. When you create an empty app, it is good practice to first build a structure of empty sheets, where each sheet represents an idea or a goal. This will give you, and others who you will share your app with, a good overview of the app. For example, let us say that you want an overview of your business's key metrics, view sales and margins by state, region and product, and also sales by city and salesperson. Instead of having all this information in one place, you could structure it by having one sheet for each of these purposes. A sheet is where charts and tables for data visualization are placed. An app can include one or several sheets. The selections that you make affect visualizations regardless of which sheets they are located on. Creating a new sheet You can create a new sheet to the app from the app overview or from the sheet navigator. Tip: You access the sheet navigator from the sheet view by clicking 4 in the toolbar. Do the following: From the app overview, click 4 to view the sheets. Click P or Create new sheet. Give your sheet a title and add a description. Click outside the text area to save the title and description. A new sheet is created. Extending the sheet area You can extend the area of a sheet vertically if you need to use more visualizations than what can fit on a screen. Before starting Note the following: You need to activate Extend sheet in the sheet properties. Each extension adds 50% of the original sheet height. If you have visualizations that scroll, this can interfere with scrolling of an extended sheet. It can be helpful to leave some empty space that allows for scrolling when you design the sheet. You can extend the sheet in two different ways: Do the following: Drag an object to the bottom of the sheet and drop it on the drop zone that appears. Click on the button Extend sheet. The sheet is now expanded by 50% of the original sheet height and you can scroll vertically in the sheet to access all content. Customizing sheet size By default, Qlik Sense uses a responsive layout for sheets that adjusts the sheet to the dimensions of the user’s screen. You can set a custom width and height for the sheet if you want to use a non-responsive layout for your sheets. This enables you to ensure your dashboard will be presented to users exactly as you create them, with no adjustments for responsiveness. You can set the height and width of a sheet anywhere between 300 pixels and 4,000 pixels. When a sheet is using a custom size, you can change the grid spacing, but you cannot use Extend sheet to change the size. Note: When a custom sheet is exported, the exported sheet is exported as a Responsive sheet. For optimal default sheet thumbnails, keep your custom size ratio to 8:5 (width:height). Do the following: Change the Sheet size setting from Responsive to Custom. Enter a width for the sheet in pixels. The sheet changes to the new width. Enter a height for the sheet in pixels. The sheet changes to the new height. Changing the grid sizing of a sheet You can adjust the grid sizing of the sheet to be able to fit more visualizations on a sheet, or have more control over how visualizations are positioned. Do the following: Change the Grid spacing setting in sheet properties from Wide (the default option) to Medium or Narrow. The sheet grid is now more dense and the grid squares are smaller. Changing the title and description of a sheet You can change the title and description of your sheets. You can either use a fixed sheet title, or a dynamic sheet title based on an expression. Do the following: In the app overview, click 4 to view the sheets. Do one of the following: If you are in grid view, ì, click the sheet title followed by clicking @. If you are in list view, î, click @. Edit Title and Description. Click outside the text area. The changes you made are saved. Tip: You can also change a sheet’s title and description in the properties panel. Using a dynamic sheet title You can also set a dynamic sheet title based on an expression in the Title expression property of the sheet properties panel. You can use any valid chart expression. For more information, see Using expressions in visualizations. If you set a dynamic sheet title, the fixed title (Title) is not used.