topic Re: Help required: When Region selected chart changes to all the district with in that Region in QlikView

Help required: When Region selected chart changes to all the district with in that Region

Tue, 29 Apr 2014 14:50:10 GMT

Hi All,

Please help, i want to show District value if i select any one Region. So if Region "Central" is selected chart changes to all the district within that Region.

Excel and Qlikview files attached.

Regards,

Manish Virmani

Re: Help required: When Region selected chart changes to all the district with in that Region

MK_QSL — Tue, 29 Apr 2014 14:53:14 GMT

Can you elaborate little more please?

Re: Help required: When Region selected chart changes to all the district with in that Region

Roop — Tue, 29 Apr 2014 15:02:32 GMT

Create a Drill-Down Group.....

Under your dimensions in your chart press the Edit Groups button.

Select New and add dimensions Region and District

Name the Group as RegionDistrict

Then incorporate this new group as a dimension in your chart replacing Region

When you click on a Region it will drill down to the districts within it

Hope this helps

Re: Help required: When Region selected chart changes to all the district with in that Region

tresB — Tue, 29 Apr 2014 15:02:49 GMT

Probably, you want to create a drill group like attached sample.

Re: Re: Help required: When Region selected chart changes to all the district with in that Region

Tue, 29 Apr 2014 18:24:48 GMT

Hi Rupert

Thanks for the solution.

I tried this but when I am not selecting any Region(clear all) it is not showing my any result(which is not correct). However when I am selecting any one region it is showing the districts under it (which is correct).

Please see the attached files.

Thanks

Manish Virmani

Re: Help required: When Region selected chart changes to all the district with in that Region

Wed, 30 Apr 2014 08:23:00 GMT

Hi Manish,

I am trying to show chart which have the Region level data, but when i select one Region it shows all the District which are mapped to that particular region. So for example i have 4 Regions so in chart 4 bubble will apear (this is done). But when i select one Region so all the District which are associated with that Region will apear.

Hope this make sense.

Excel and Qlikview file attached in the original post.

Regards,

Manish Virmani

Re: Re: Help required: When Region selected chart changes to all the district with in that Region

Wed, 30 Apr 2014 08:27:28 GMT

Hi Tresesco,

I tried but there is no data showing. It seems i did something wrong. Please see the attached file.

Re: Re: Help required: When Region selected chart changes to all the district with in that Region

Wed, 30 Apr 2014 18:36:15 GMT

Hi Manish,

Please confirm is this possible?

Thanks

Manish Virmani

Re: Help required: When Region selected chart changes to all the district with in that Region

d_pranskus — Wed, 30 Apr 2014 18:48:44 GMT

Hi Manish

When you do not select Region this will give multiple expression values for your dimension combination. So you must use some aggregation function your expression. Please find attached sample. I am not sure if the percentage values are correct though. It is always good to calculate ratios in chart, like this SUM(Value1)/SUM(Value2), for example for margin percentage it would be (SUM(Sales) - SUM(Cost)) / SUM(Sales).

Cheers

Darius

Re: Help required: When Region selected chart changes to all the district with in that Region

Wed, 30 Apr 2014 19:16:43 GMT

Thank you so much Darius!!

This is perfect and really helpful.

Thanks

Manish Virmani

Re: Help required: When Region selected chart changes to all the district with in that Region

Wed, 30 Apr 2014 19:20:08 GMT

Hi Darius

Just wants to know can we also change the cyclic group to Radio Button or is there any other option. I don't want to use the cyclic button but I need the functionality of cyclic group.

Hope this makes sense.

Thanks

Manish Virmani

Re: Help required: When Region selected chart changes to all the district with in that Region

d_pranskus — Wed, 30 Apr 2014 20:27:42 GMT

I think it is not possible.