Qlik Community

Qlik Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Employee
Employee

Many organizations have a dedicated person, or a group of people, responsible for creating visualizations to help guide business users on their decision-making process. For the lack of a better term, let's call those people the "Dashboard Developers."

Every day they face the task of transforming a collection of requirements into an insightful combination of data visualization objects. That can be a challenge.

As a dashboard developer, let's imagine we are creating an application for a group of users within the Sales organization. These individuals need to perform specific tasks to support their teams, and we have received the following set of requirements for this use case:  

  • All the focus for the Sales Opps analysts will be around the current quarter, so we need the application to open with a particular set of selections.
  • An application that has visual cues on the order processing requirements for each sales representative as well as detailed information about specific deal transactions.
  • Some users have unique ways of performing their analysis, and they need to have alternatives when customizing visualizations to reduce time to act.
  • We also need to provide extra details based on particular types of orders.
  • The analysts are spread across different regions and use different devices for the analysis, we need the application to support this.

A dashboard developer, with knowledge of both QlikView and Qlik Sense, will most likely think that only QlikView can meet the majority of the requirements listed above. However, let's check how some of the new Qlik Sense capabilities can help to solve this business case and give the flexibility for self-service data exploration.

After loading and validating the data, we can start creating the visualizations to capture the insights. To address the need to start the application with a set of selections, we can define a default bookmark for the app. Every time a user now opens the application the selections contained in the bookmark will be applied.

DefaultBookmark.gif

We need to highlight sales reps by the number of deals that require a manual order processing. There are 3 segments used to rank sales reps that need proactive support to speed up the ordering processing. Multiple visualizations require using the segments for highlighting the sales reps.  To achieve this, we can create a measure in the Master Items and add a segment coloring configuration, which allows for multiple charts to use the same measure.

segment-colors.png

For the detailed transaction analysis, we need to create a pivot table to display the information about the order processing and it needs to have extra information in cases that require manual processing.  There are many transactions and this can be confusing for the analysts.   To simplify, we can add a calculation condition for the pivot table to prevent it from displaying multiple transactions in addition to a column with the extra manual processing required information in case the transaction has a manual process flag. To do this, we can add a show condition expression, making the column available only when meeting the criteria.

pivot-table-condition.png

To address the requirement around supporting the use of different device types for analysts varying from traditional desktop computers, laptops or mobile devices, the information density on the client can be adjusted by enabling the touch screen mode. This makes the actions performed on the client more suitable for a finger interaction.  For example, an adjusted row height in a pivot table.

touch-screen.png

Developing a Qlik Sense application could require different preparation steps and the need for a broader toolset available to developers. That is one of the advantages of Qlik Sense's flexibility to adapt to various use cases.

We have initiated a continued delivery of improvements for Qlik Sense focused on Advanced Authoring.  You can read about what was delivered in the first wave of Advanced Authoring enhancements in the Qlik Sense June 2018 release “Advanced Authoring” capabilities in Qlik Sense!

The Qlik Sense September 2018 release brings the second wave of these improvements, to support developers who need their applications to perform specific tasks.  The second wave of Advanced Authoring capabilities empowers developers to create applications to solve specific use cases and provides an improved set of tools to make their tasks more manageable and automated.

In addition to the requirements included in the “day in the life’ use case, the September 2018 release also delivers improvements to the experience when creating the expressions for measures, such as the ability to search in all sections of the Expression Editor dialog as well as getting a hyperlink directly to the Qlik Sense Help page for a particular function. We have also introduced the custom sheet size to allow developers to specify the size of the sheet in pixels and turn off the responsive design, giving the dashboard developer the choice of how a sheet behaves on different devices.

search.png

Custom Sheet Size.gif

We would love to hear your feedback on how you plan to leverage these capabilities!   Please visit our Qlik Sense Advanced Authoring space here on Qlik Community to have a dialog with Qlik Product Management on this high value focus area.

7 Comments
Creator III
Creator III

Hi.

Advanced authoring is a cool initiative as it goes along the lines of creating Guided Analytics.

As users are beginning to adopt QS as their mainstream tool they're left increasingly desired to create custom analytics .

So here are a few suggestions:

1. Create a group called widgets in QS interface which has some nifty features that could include;

  • Slider, Input Box, Drop-down. CRITICAL
  • The QS Variable extension in Qlik Branch is pretty good and maybe you can try to emulate it.
  • Especially, I like it's ability to create a Label and assign a numeric value to it in the drop-down option. This eliminates the need to create Data Islands.
  • Checkboxes are desirable but not critical.

2. Calendar object is pretty handy.

3. Container Box.

4.  Ability to show/hide sheets and objects .

5.  Ability to re-use master measures within the expression itself.

6. Dynamic field selections based on triggers / events.

7. Action buttons.

8. Unhashed sheet and object names. Easy to read and be used in Nprinting.

1,880 Views
Employee
Employee

Hi Vishnu, we are currently working on every item on your list.

The Qlik Sense November 2018 release will cover most of the items you are mentioning here, and we plan to continue to deliver more capabilities on the Advanced Authoring roadmap.

1,880 Views
Creator III
Creator III

Caique,

Even 5 and 8?

Wow - Golden days ahead...

0 Likes
1,880 Views
Employee
Employee

Numbers 5 is on the roadmap, but not planned for the November 2018 release.
Number 8 is outside of the Advanced Authoring scope as it relates more to Collaboration

1,880 Views
Creator III
Creator III

Caique,

Sorry to bother you. Mike talks about "Dashboard Extension Bundle" being an optional install - see below. Can you comment on whether this bundle will be available on Qlik Cloud?

Your response is appreciated.

Thanks!

3.JPG

0 Likes
1,880 Views
Employee
Employee

Tagging Patric Nordström bps

0 Likes
1,880 Views