I'm a Qlikview beginner and am struggling with the finer points of chart manipulation.
In this case, my problem is with pie charts. I have a line sand chart that has two Dimensions - Year and Customer - and one Expression, sum(Amount). The chart has a fast change option to a Pie Chart. However, because of these Dimensions and Expressions, and Pie Chart is ugly and very crowded - in the middle of the Pie is the aggregation of sum(Amount) by Customer across all years, and around it are slivers representing each sum(Amount) for every Customer in every year.
#1 - Is there a way where I could manipulate this, and break it out so that instead I would have multiple pie charts, each providing sum(Amount) for every customer for one year? I.e. if the period was 2001-2008, could I have 8 smaller pie charts in the chart area?
#2 - A related question would be - is it possible to conditionally change Dimensions for Fast Type Change - i.e. can I set a condition to remove the Year Dimension when the chart switches to a Pie Chart?