Skip to content

Adhoc

Overview

Adhoc Report enables users to create custom tables using data from master tables, providing flexibility to add, remove, and rearrange data columns. This guide explains how to set up and customize Adhoc Report within your Qlik Sense application.

Accessing Adhoc Report

Step 1: Open your Qlik Sense Hub in a web browser. Choose the application where you want to explore the Adhoc Report extension.

Step 2: Click on Edit Sheet. Locate the sheet within your selected Qlik Sense application.

Step 3: Locate Custom Objects Section. Look for the "Custom Objects" section within the sheet editor.

Step 4: Within the "Custom Objects" section, find the imported Adhoc Report extension under the SenseOps category. Click and drag the Adhoc Report extension onto the sheet workspace.

Watch the accompanying GIF video to learn how to access Adhoc Report.

Customizing Adhoc Report

Data mode Setup

1. Open Adhoc Report in Edit Mode:

  • Ensure you're in edit mode on the sheet.

  • Select the Adhoc Report template.

2. Configure Data Set Mode:

  • Access the properties panel and locate the Data Set Mode dropdown.

  • Choose between Master Object or Custom and set the desired parameters.

  • For Master Object, specify the type of master visualization.

Screenshot

  • For Custom, manually add required data fields.

Screenshot

Visualizations and Appearance Settings

1. Access Visualizations Settings:

  • In Edit mode, click on Visualizations Settings under Appearance.

2. Customize Appearance:

Screenshot

  • Show Left Panel by Default: Toggle to expand the left panel on sheet loading.

  • Show Data Set Menu: Show or hide the Data Set menu in the template.

  • Show Title: Display or hide the title for the selected Data Set.

  • Title Color: Set the font color for the Data Set title.

  • Font Style: Customize the font style for the Data Set title.

  • Show Visualization Switch: Show or hide the visualization switch in the report.

  • Visualization Switch as: Toggle between dropdown or icon for the visualization switch.

Customizing Dimensions and Measures Appearance

Dimension and Measure Settings:

  • Both the Dimension Menu and Measure Menu share the following customization options:

  • Menu Title: Change the title of the menu.

  • Selected Background Color: Set background color for selected items.

  • Selected Color: Customize text color for selected items.

  • Select all Fields if no values are selected: Automatically select all fields in the next dataset.

Screenshot

Screenshot

Watch the below video as measures and dimensions are customized with precision to enhance your reporting.

Sorting Dimensions and Measures:

  • Rearrange Dimensions and Measures: Use the sort bar to change the order of dimensions and measures based on your preferences.

Screenshot

Example Demonstration

Watch the video below for a demonstration on generating custom tables using Adhoc Report: