topic Re: different graphs on drilldown for each category? in QlikView

different graphs on drilldown for each category?

Sun, 15 Dec 2013 18:35:36 GMT

Hi,

I have a bar chart that shows different categories on x axis and the measure is shown on y axis. My customer wants me to show different other charts when I drilldown to each category on the graph. Each drilldown chart has a seperate kind of chart presentations and some even have a different expression. He wants to be able to return to original graph if he goes up to the category.

I want to know if this is possible in Qlikview and how to do it

Arif

Re: different graphs on drilldown for each category?

Anonymous — Sun, 15 Dec 2013 18:57:20 GMT

Syed

You can use the function GetCurrentField( YourGroupName ) to return the of name of the active field in a group.

Then once you know what your active group is then you can use that in expressions to show / hide your Chart Objects as per you needs, or do other jiggery pokery.

Best Regards, Bill

Re: different graphs on drilldown for each category?

Sun, 15 Dec 2013 19:06:07 GMT

Hi Bill,

Many Thanks for getting back to me on this so quickly. Basically I need to get the series inside the group and show different charts based on data

For example, I have a chart that is showing hours for different departments. Support a bar chart showing hours for Sales, Marketing, Accounts etc department. The dimension here is Department

If I click on sales to drilldown further into this, I want to see a crosstab showing hours and other details. If I want to drilldown to marketing, then I want to see some other chart type like a gantt chart maybe etc. This is just an example

Can you give me a hint on how can I achieve this. I think I need to play with showing and hiding different charts above each other but I first want to know how to set a variable if I click on a point in the top level chart that is showing hours for different departments

getcurrentfield(groupname) will give me the current level of dimension in the drilldown group but it does not give me information about the exact datapoint/series inside the dimension

Arif

Re: different graphs on drilldown for each category?

Sun, 15 Dec 2013 19:12:46 GMT

Hi Bill,

It was a bit simple that I thought. I simply needed to put a condition in the the layout the Deparment = 'Sales' and it showed the chart if I clicked on the Sales inside the chart.

Arif

Re: Re: different graphs on drilldown for each category?

Anonymous — Sun, 15 Dec 2013 19:16:39 GMT

Syed

Attached is a sample qvw that hides / shows Chart Objects depending on getcurrentfield(groupname)

I must admit that I am not sure what you mean by does not give me information about the exact datapoint/series inside the dimension could you clarify, But it could be the GetFieldSelection() function you are in need of.

Best Regards, Bill

Re: Re: different graphs on drilldown for each category?

Sun, 15 Dec 2013 19:20:50 GMT

Yes, It was the getfieldselection I needed. I wanted someway to get an expression of what data point inside the field was being selected or drilled down. Based on that, I needed to show different graphs. Now I am thinking about how to return to the original graph once the user wants to get back to the original chart. I know I can use a button to set a variable to show the original graph and hide others, but I am now trying to see if I can do it without using an external object out of the graph. I want to make it look like a drillup and drilldown

Arif

Re: different graphs on drilldown for each category?

Anonymous — Sun, 15 Dec 2013 19:36:00 GMT

Syed

Is there a reason why you could not just drill up with the up arrow by the Group dimension display ?

Best Regards, Bill

Re: different graphs on drilldown for each category?

Sun, 15 Dec 2013 20:09:11 GMT

because I need to show a separate type of graph and set of data upon drilling down inside each data point in the top level.

Suppose On x axis, I have four data points. Sales, marketing, accounts, hr etc. Upon drilling down inside each of these records, I need to show a separate graph and data. Is it possible to do it inside the same chart and using drilldown?

I believe that if I want to show a separate kind of data and graph, I cannot achieve it using drilldown but I actually need to show and hide these separate graph but please correct me if I am wrong