Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

How Do I Keep QlikView Formatting in my Report?

cancel
Showing results for 
Search instead for 
Did you mean: 
Bjorn_Wedbratt
Former Employee
Former Employee

How Do I Keep QlikView Formatting in my Report?

Last Update:

Nov 13, 2015 4:23:48 AM

Updated By:

Bjorn_Wedbratt

Created date:

Nov 13, 2015 4:23:48 AM

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. Here is how to verify that data will be exported from QlikView and presented in the final report as it is formatted in QlikView.

    
    
        
          

Entire Table to Keep QlikView Formatting

                    
            Entire-Table-to-Keep-QlikView-Formatting.png                    
          

After you have added a QlikView object as a table:

  1. Right click on the table node
  2. Select Properties
  3. Make sure the Keep Source Formats box is checked. If not, select it.

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

        
        
        
          

Only Select Columns to Keep QlikView Formatting

                    
            Only-Select-Columns-to-Keep-QlikView-Formatting.png                    
          

If you want to allow Excel formatting for the majority of columns, uncheck the Keep Source Formats box for the table as a whole and proceed as follows:

  1. Expand the table node by clicking on the '+' to its left
  2. Right click on the node for the column you want to maintain QlikView formatting in
  3. Select Properties
  4. Select the Keep Source Formats box so that it is checked

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

        
        
    
  
Labels (1)
Version history
Last update:
‎2015-11-13 04:23 AM
Updated by: