Skip to content

Adhoc Report

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 Qlik Sense Application: Open the Qlik Sense Hub and choose the application where the Adhoc Report will be added.

Step 2. Enter Edit Mode: Navigate to the sheet or create a new sheet where you plan to use the Adhoc Report. Enter the edit mode to make changes to the sheet.

Step 3. Access Custom Objects: In the left panel, click on "Custom Objects" to open the custom objects menu.

Step 4. Select SenseOps Extension: Locate and select "SenseOps" from the custom objects menu.

Step 5. Add SenseOps Straight Table: Find the "SenseOps Adhoc Report" extension within the SenseOps category. Click and hold the Adhoc Report, then drag and drop it onto the sheet canvas.

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: