topic Drill down chart in QlikView

Drill down chart

Wed, 30 Oct 2013 09:45:29 GMT

Hi,

I have a requirement where I need to get the different chart based on the different fields selected form the drill down.

For eg,

when i click on day ,I should get a pie chart and when I click on week ,should get a bar chart

Thanks and regards,

Prathima.

Re: Drill down chart

sbaldwin — Wed, 30 Oct 2013 13:57:02 GMT

Hi, you should try creating different charts placing one over the top of another then use conditional visibility with the GetCurrentField function to determine the drill level of your group.

Thanks

Steve

Re: Drill down chart

Wed, 30 Oct 2013 14:02:55 GMT

you may create a chart and enable the feature that gives you the possibility of changing the chart type, and instead of using 1 dimension, use a group of dimensions, so you will give the user the capacity of changing the type of chart and it`s dimensions freely.

I hope it helps.

Re: Drill down chart

Thu, 31 Oct 2013 04:53:47 GMT

Prathima,

Please find attachment hope this will help you.

Best Regards,

Re: Drill down chart

Thu, 31 Oct 2013 09:00:51 GMT

hi,

I have used the function in the cyclic drill down group.

for eg:Groupname=drillYear

fileds are:month(created_date)

year(created_date)

GetCurrentField([drillYear]) does'nt work in the above scenario

Re: Drill down chart

Thu, 31 Oct 2013 09:04:49 GMT

how to enable the features that give the possibility of changing chart type?

Re: Drill down chart

Thu, 31 Oct 2013 09:05:59 GMT

hi,

As am using personal edition,not able to open the qvw file shared by you.

could you please explain me the steps involved?

Re: Drill down chart

Thu, 31 Oct 2013 09:15:35 GMT

I create multiple chart in this and control its visibility with conditions.

Re: Drill down chart

Thu, 31 Oct 2013 09:52:41 GMT

Requirement here is to display the chart based on the cyclic group fields selected.

and those group fields are function.For eg:month(created_date)

Re: Drill down chart

Thu, 31 Oct 2013 11:15:01 GMT

in the chart properties go to general, in the bottom right there are some checkboxes with the chart type for quick change, you check the ones you want and see it done ^^.

Hope it helps