Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Bhavi
Contributor
Contributor
‎2021-07-03 02:22 AM

Changing Charts in Drill down objects

Hello all,

I want to create a Bar Graph Showing Years and total sales 

and when drill down it should show Quarer Sales in bar 

But then monthly Sales should be reflected with line chart as user wants to see trend in months 

How to change in Charts in between visualization?

 

Please help

636 Views
0 Likes
1 Reply
rubenmarin
MVP
MVP
‎2021-07-03 03:30 AM

Hi, you can have 2 different charts, set both charts in a container and use 'Show condition' to show/hide them.

The bar chart by year can have a condition like Count(Distinct Year)>1, and the combo chart by month Count(Distinct Year)=1.

The tricky part could be to show quarter sales in a chart by month, for this I think you will need a field QuarterSales wich summarizes in months 3, 6, 9 and 12 the sales of the other months of each quarter.

608 Views