Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

How do I drill down in a bar chart?

Good day

I have a bar and line chart with dates as a dimension. The bar display the monthly ave and the line the quarterly ave.

Sum({<TypeDrill={Hybrid},[MonthIndex] = {'<=$(vMaxPeriod)'}>}MetersDrilled)/sum({<TypeDrill={Hybrid},[MonthIndex] = {'<=$(vMaxPeriod)'}>}Repairs)/4

Now if I only want to see the current year's data the quarterly ave is recalculated starting at 0.

This is a misinterpretation of the data as it started at 0 in 2016.

How do i fix it?

4 Replies

Would you be able to share a sample to show the issue?


Good day

Here is my graph.

When you make a selection, it recalculates the quarterly ave as seen below from 655 to 356.

How do I stop it from recalculation. I only want to zoom in on the data for those periods.


Creator II
Creator II

You Setting a new Dimension by Group working

set the fields in the Group


The Group is your new dimension

Would you be able to share the qvw to test?