Qlik Community

Ask a Question

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Jennell_McIntire
Employee
Employee

A couple of years ago I wrote a blog on customizing straight tables in QlikView explaining how you can add an ad-hoc report to your QlikView app.  So, I thought I would share how you can now create a custom report in Qlik Sense using the Climber Custom Report extension.  The Climber Custom Report is an extension that can be added to your Qlik Sense app to give users the ability to create their own ad-hoc reports.  In this blog, I will show you how easy it is to add a custom report to your app using Qlik Sense Desktop.

  1. The first step is to download the Climber Custom Report extension from Qlik Branch, unzip it and put it in your Extensions folder (C:\Users\xxx\Documents\Qlik\Sense\Extensions).
  2. In your Qlik Sense app, create a table with all the possible dimensions and measures a user may want to see in a report and then add the table to master items.  The table may look something like this: table.png
  3. Add the Climber Custom Report extension to a sheet in your app and then you are ready to create a report.
  4. In the Visualizations drop down, select the report you just created.  All tables that are in your visualization master items will be listed in the drop down.  Once the table is selected, the dimension and measure lists will be populated with the dimensions and measures that are used in the table as seen below.dimensions and measures.png
  5. Select the dimensions and measures you would like to add to your report by clicking on them.  Your report will look something like the image below after you make some selections.  The dimensions are blue and the measures are orange.selections.png
  6. From the custom report bar above the chart, you can remove a dimension or measure by clicking the x and you can change the order of the columns by dragging and dropping the dimensions and measures into the order you would like them to appear in the report.

And that is it - it is that simple to add a custom report to your Qlik Sense app.  With Qlik Sense self-service, a user can create a report by dragging and dropping dimensions and measures into a table but what I like about the Climber Custom Report extension is it makes everything available to the user with a clean, professional and organized look.  Download it now and test it out for yourself.  See the extension in action in the Situational Awareness demo.  Note - the Climber Custom Report extension works in Qlik Sense 3.0 and higher and, like all extensions, are not supported by Qlik.

Thanks,

Jennell

32 Comments
michael_nordstr
Partner
Partner

If you want to know more, here is a short video presentation of the Custom Report https://youtu.be/mCb2t4aNppE

5,088 Views
michael_nordstr
Partner
Partner

And thank you very much Jennell for all those kind words about our extension 🙂

0 Likes
5,088 Views
phaneendra_kunc
Partner
Partner

I wish there is a Pivot table option as well.

0 Likes
5,088 Views
michael_nordstr
Partner
Partner

Who knows what the future might bring 😉

5,088 Views
simondachstr
Luminary Alumni
Luminary Alumni

I'd love to see this integrated with the Vizlib Table too!:)

5,088 Views
paulyeo11
Master
Master

Hi All

I have try and notice that this branch is quite good , because it can make all table report in one sheet. ( Hope that some one can make the similar branch , to bring all the chart in one sheet using the same approach , that will be very nice.

I found some issue here , hope some one advise me any work around ?

custom report extension how to make text black ground white

Thank you very much for the person who design this branch.

Paul Yeo

0 Likes
5,088 Views
michael_nordstr
Partner
Partner

Hi Paul,

I posted a reply in your thread.

/Michael

0 Likes
4,195 Views
paulyeo11
Master
Master

Hi Michael

I like your climber report so much that i will make use it for my next meeting presentation. Now i found that the table i always need to click the sort , as by default all table sort by dimension , it there a way i can force it sort by certain column ? Hope you can advise me.

Re: How to make Climber custom report always sort from Hi to Lo ?

0 Likes
4,195 Views
paulyeo11
Master
Master

Hi All

I have post a question , hope some one have try , can share with me.

QS After Add the chart to Visualization Do you guy still need to keep the chart ?

0 Likes
4,195 Views
paulyeo11
Master
Master

Hi Jennell

Since Michael have develop a very good extension , Hope that Qlik can consider add this into QS ver 4.

can QS add climber custom report extension into QS so Cloud can be access.

Paul

0 Likes
4,195 Views