Qlik Community

Qlik Design Blog

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

Employee
Employee

In Qlik Sense, alternate dimensions and measures are available providing users the option to change the dimensions and/or measures being used in a chart.  Alternate dimensions and measures are defined in advance and provide users with different views of the data all in one chart.  Alternate dimensions and measures can be added to a visualization in the Properties panel.  In the image below, there is a bar chart with Product Sub Group as the dimension and Sales $ as the measure.  There are also two Alternative dimensions: Product Group and Product.  Alternate dimensions and measures can be added by clicking the Add alternative button and selecting or entering the new dimension or measure.

bar chart.png

By default, the bar chart above shows the Sales $ by the main dimension for the chart, Product Sub Group.  Since there are alternative dimensions set up, the user can also view the Sales $ by Product Group or Product by simply clicking the arrow next to the dimension name on the y-axis and selecting either Product Group or Product.

dimension switch.png

In Qlik Sense 3.0, the ability to change the dimension from the axis was added.  Users can also change the dimension or measure by opening the Exploration Menu and changing the dimension or measure.

dimension switch panel.png

Adding alternate measures is just as easy.  In the image below, two alternate measures were added to the Margin Amount Over Time line chart: Sales $ and Budget $.

line chart.png

A few things to be aware of when using alternate dimensions and measures:

  • In bar, line and combo charts, the title needs to be visible on the axis of the alternate dimension/measure so the user can see the arrow to click on to change the dimension/measure.  If you prefer not to show the title, then the user can still change the dimension/measure by going into the Exploration Menu.
  • Alternate dimensions and measures can be added to all chart types but they can only be changed in the visualization (via the axis) in bar, line and combo charts.  In other chart, they can be changed in the Exploration Menu.

If you are familiar with QlikView, you may find alternate dimensions and measures to be similar to the cyclic group that is available in QlikView.  They are both great features because it allows the user to have one visualization with numerous views.  This is ideal in keeping your sheets uncluttered.  Instead of having the same visualization repeated using different dimensions or measures, you can now have one chart with alternate dimensions and/or measures.

Thanks,

Jennell

13 Comments
Specialist
Specialist

HI Jonas

Can we use the getobjectfield of let's say a bar chart where we're using alternate dimension in other charts as well?

Regards

Pratyush

0 Likes
5,302 Views