topic Re: Drill Down Functionality in QlikView

Drill Down Functionality

Thu, 06 Nov 2014 18:09:16 GMT

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

Re: Drill Down Functionality

Gysbert_Wassenaar — Thu, 06 Nov 2014 18:22:25 GMT

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

Re: Drill Down Functionality

Thu, 06 Nov 2014 18:31:18 GMT

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.

Re: Drill Down Functionality

Gysbert_Wassenaar — Thu, 06 Nov 2014 18:36:21 GMT

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?

Re: Re: Drill Down Functionality

Thu, 06 Nov 2014 18:52:09 GMT

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

Re: Drill Down Functionality

rwunderlich — Thu, 06 Nov 2014 19:02:35 GMT

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

Re: Re: Drill Down Functionality

Fri, 07 Nov 2014 15:02:31 GMT

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

Re: Drill Down Functionality

Gysbert_Wassenaar — Fri, 07 Nov 2014 15:14:41 GMT

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.

Re: Drill Down Functionality

Peter_Cammaert — Fri, 07 Nov 2014 15:25:05 GMT

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.

Re: Drill Down Functionality

Fri, 07 Nov 2014 18:56:39 GMT

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.

Re: Drill Down Functionality

MarcoWedel — Fri, 07 Nov 2014 20:48:14 GMT

Hi,

make sure, you have no static scaling defined:

Those fields should be empty.

regards

Marco

Re: Drill Down Functionality

MarcoWedel — Fri, 07 Nov 2014 21:31:04 GMT

sometimes it's the obvious that we can't see...

regards

Marco