Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New Contributor II

How can I create a drill-drop dimension for a group of states?

Hello all,

I am working on a presentation for Medicaid spending and I'm using raw data comprised of totals from all 50 states. In my visualization, I would like to add a drill-drop dimension to a bar chart, so that I start out with four to five groups of states (such as East Coast, West Coast, Midwest, etc.) and have the ability to drill down into them so I could see the states that make up each group along with their respective totals. I was able to place all 50 states in a bar chart and I have been stuck ever since. I would like them to be in alphabetical order. I'm attaching a screenshot of what I have so far if it helps, thanks again in advance! I truly appreciate it.



Tags (2)
1 Reply
Esteemed Contributor

Re: How can I create a drill-drop dimension for a group of states?

If you have a dimension containing the east, north, south etc information; let's called region for example;

you can create a drill down dimension as a master dimension.

first dimension: region, second one: location.

see the video below:

Qlik Sense Desktop – Drill-down Group Dimension - YouTube

Community Browser