Drill Down Functionality

[#1]

I made a drill-down functionality button for my combo chart, however when I switch a different topic in the drill down box it will not change the y axis to the different topic. Is there a way to make the y axis values change to each topic I select in the drill down box?

Thank you for your help

[Gysbert_Wassenaar]

What do you mean 'different topic'? How should y-axis values change?

[#3]

Specifically in my combo chart, I have customer, product, country and salesrep in the drill down functionality box. All those topics have different sales values. So when I switch between these topics my y-axis value doesn't change to the correct sales values for each topic. So in my combo chart, the bar chart will be out of whack and display weirdly. I need my y-axis to correlate with the right values for each of those topics. I hope that makes sense.

[Gysbert_Wassenaar]

Sorry, no. It doesn't make sense to me. The y-axis is used for values from expressions. I don't see how changing a dimension (drilling down to another dimension in the group) would muck that up. Can you post a document that demonstrates the problem?

[#5]

I have attached my qlikview file with the combo chart. I hope that works.

[rwunderlich]

Your expression will need to be a conditional that tests the current group field and performs the appropriate calculation. Something like:

=if(GetCurrentField('mygroup') = 'Product', .....

-Rob

[#7]

Thank you for your help. I have not been able to figure it out. I have attached my chart below. The equations I am using are:

bar chart  for sales- sum(sales)

the symbols(small circles) in the bar chart for margin- sum(margin)

the line graph for margin %- sum(margin)/sum(sales)

the drill down function I created is called KPI which involves- customer, product, salesperson, country

So to get the drill down to correlate in the bar chart, do I need to make an expression resembling this:

sum(sales)=if(GetCurrentField('KPI')='product','customer','salesperson','country' ???

I am confused at how to add this type of expression to my chart

[Gysbert_Wassenaar]

It doesn't work. Screenshot scrying is not one of my skills. Perhaps you can post the .qvw document that is giving you trouble instead.

[Peter_Cammaert]

You mean to say that you have created a Combo-chart with three fixed expressions called, Sales Amount, Margin and Margin %, and your X-axis consists of a Cyclic group that contains Product, Customer, SalesPerson and Country?

Should work as-is. IF it doesn't, something else is wrong. In that case, please upload your QVW or a reduction with just the object and some sample data.

Note that with your group type selection (Cyclic group) can can only switch between Dimension fields, not drill-down.

[#10]

yes thats what I mean. I have a cyclic group. The combo chart works fine, the problem is when I switch between product, consumer, salesperson and country in the cyclic group the y-axis will not correlate with the correct values.

for example when i select customer the y-axis will display min -20,000 to max 220,000 and it will stay that way even when I change the cyclic group to product which needs a y-axis from a min -20,000 to max 410,000.

What I would like to do is make the y-axis values to  change each time i switch between the cyclic group.