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

[#1]

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

[MK_QSL]

Can you elaborate little more please?

[Roop]

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

[tresesco]

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

[#5]

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

[#6]

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

[#7]

Hi Tresesco,

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

[#8]

Hi Manish,

Please confirm is this possible?

Thanks

Manish Virmani

[d_pranskus · Accepted solution]

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

[#10]

Thank you so much Darius!!

This is perfect and really helpful.

Thanks

Manish Virmani