In QlikView we saw a lot of users requesting a customizable straight table. Now that is possible in Qlik Sense too! The Custom Report extension allows you to create custom tables based on data in master tables. (For more info on customizable tables in QlikView, check out this link.)
First thing to do is create a table and make it a master item. The table is now accessible in Custom Report and you can select to show any or all measures and dimensions. Number format follows from the master item so no need to redo formatting! For full feature list see screenshots below.
Works only with Qlik Sense 3.0 and up!!
- Create Master Item Table
- Select master item in the drop-down and choose what to show in the dimensions and measures. The custom table will be updated accordingly. Only dimensions and measures that are used will be calculated by Qlik Sense.https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table
- Sorting of columns by drag and drop.
- The table used is a standard Qlik Sense table so all standard features such as export and sorting are available.
- You can use tags in the master items to show only relevant master item tables. Choose your tag in the settings. (In the picture we used the tag "Custom report" but you can of course choose any tag you want.)
- Download the latest version of Qlik Sense (3.0 or higher)
- Qlik Sense Desktop
- To install, copy all files in the .zip file to folder "C:\Users[%Username%]\Documents\Qlik\Sense\Extensions\cl-customreport"
- Qlik Sense Server
- See instructions how to import an extension on Qlik Sense Server
- You can use tags in the master items to show only relevant master item tables. Choose your tag in the settings. (In the picture we used the tag "Custom report" but you can of course choose any tag you want.)
- If you don't like the colored dimensions and measures it is possible to make them colorless. There is also a default sorting option for the dimensions and measures.
Contributing to this project is welcome. The process to do so is outlined below:
- Create a fork of the project
- Work on whatever bug or feature you wish
- Create a pull request (PR)
I cannot guarantee that I will merge all PRs.
Karl Fredberg Sjöstrand @ Climber
See CHANGELOG
The software is made available "AS IS" without any warranty of any kind under the MIT License (MIT).