Keeping QlikView formats

When creating templates for generating reports, you will sometimes want to present information with the formatting as it is in QlikView. This is the default setting. You can verify that data will be exported from QlikView and presented, in the final report, as it is formatted in QlikView.

Keep QlikView formatting for an entire table

After you have added a QlikView object as a table, do the following:

1. If the Properties pane is not open, right click on the Table node in the template editor, and then select Properties.
2. Make sure that the Keep Source Formats check box is selected.

The content for all cells in all columns of the table will be exported from QlikView with the formatting intact.

Keep QlikView formatting for selected columns

If you want to allow Excel formatting for the majority of the columns, clear the Keep Source Formats check box for the Table node, and do the following:

1. Expand the Table node.
2. If the Properties pane is not open, right click on the node for the column in which you want to maintain QlikView formatting and select Properties.
3. Select the Keep Source Formats check box.

The content for all cells in the selected column of the table will be exported from QlikView with the formatting intact. You can do this for as many individual columns as you need.