Tuesday, November 7, 2017

QLIK VIEW SHEETS

sheet can be considered the most basic component in QlikView. A document usually contains several sheets, which is useful when one wants to achieve a more structured layout. Any sheet object can be put on any sheet. The sheets will, however, still be logically connected, i.e. a selection made on
one sheet will affect all sheet objects on all other sheets.

Each sheet has a tab attached to it. Containing the name of the sheet, the tab helps you find the sheet you are looking for. By clicking on a tab, you activate the sheet attached to it. You recognize an active tab from the bold text.

Adding a sheet:

1. Choose Add Sheet from the Layout menu. A new sheet appears.
2. Click somewhere on the empty sheet with the right mouse button and choose Properties from the menu that appears. The Sheet Properties dialog will now appear.

Moving a sheet:

 Click on the tab of your newly created sheet withthe right mouse button. From the float menu that
opens, choose Promote Sheet it will move one sheet forward, click  demote it will move one sheet backward.

Adding new sheet objects:

If you right-click somewhere on the sheet , then select New Sheet Object, you see this list
of all the sheet objects that can be used in QlikView.

Moving a sheet object:

To move a sheet object we can use mouse or CTRL+Arrow or CTRL+SHIFT+Arrow.
Also we can undo our changes by using CTRL+Z.






No comments: