Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 

Alternative Measures Question

I have a line chart with a Group of Year-Month and an Area of Level of Automation.

I calculate the percentages for Each Level of Automation for each Year-Month.  So each Year-Month total 100%.

The expression is this 

Count(Distinct (ShipmentNumber) / Count(distinct Total  <[Year-Month]> ShipmentNumber

Works great.

Now I want to add an alternative measure for  Year and see the percentages for each Automation Level by Year.  The above expression does not work for Year.  I need to change <[Year-Month]> to <Year> .  I can break this into 2 charts and that works.  

But is there a way to accomplish this in a single chart?

1 Reply
Specialist II
Specialist II

Hello @rittermd I am not 100% sure I am getting what you really need to achieve, but have you tried with Combo Chart instead of using a Bar Chart or Line Chart?

Help users find answers! Don't forget to mark a correct resolution 🙂