Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How can I display 3 levels of information on a line chart's x-axis like what excel can do

Hi,

Many of the engineers in my organization is using the pivot tables to create charts in Excel. Often, the charts will have 2 or 3 levels of information on the X-axis (see attached image with 3 levels of info). I can't find a charting feature or method in QS to do the same. Appreciate the community's help with a solution.

Thanks!

Timsoh

Labels (1)
3 Replies
Highlighted
Creator III
Creator III

Hi,

Did you try drill-down dimension? like this: https://www.youtube.com/watch?v=55TN-bZ3WWU

 

Highlighted
Contributor II
Contributor II

Thanks Quy_Nguyen. Let me watch and experiment. regards, Tim

Highlighted
Contributor II
Contributor II

Hi Quy, I experimented with the drill down dimension and while it can do as per what the video described, it did not achieve what the Excel Pivot chart with 3 levels of info on the X-axis can give to the analysts. By drill in, I can see info at the breadcrumb level but not at the breadload level. Also the drill down can only apply to a single selection. Let's say I have the production lot measure data for every month from 2017-2019. The Excel pivot chart will be able to display each production lot's measure from 2017-2019 so we can see how we are doing for each month and a very quick comparison month on month, year on year, lot on lot or at which month after countermeasure implementation that there was a step improvement of the measure.  For the drill down dimension approach, I can only select 1 year, drill down to the months, select 1 month before I can see the production lot for the month. I cannot select 2 years and drill down further.  Any alternative suggestion?