Drilling down from sold items into further detail

[Anonymous]

Hello Everybody,

I have a question here:

I have a pie chart that shows the amount of sold, reserved and on stock items.

What I want to do now is when clicking on sold, I want to see all categories where items have been sold. When I click on the categories I want to see the brands where items have been sold.

So sort of a drill down.

The data is stored in Excel... so I thought I can simply create a group of the categories and brand and add it to the dimension of sold items.

Is that somehow possible?

spijatida

[marchoctober · Accepted solution]

Hi, create Drill Down group from dimensions tab in chart properties. Structure them as you want, f.e.

Status (sold, reserved, stock)>Categories>Items.

And you'll be able to drill down in chart.

Replase my names (Status, Categories, Items) wit those, that you are using within data model.

[Anonymous]

Thanks..

looks like it was too early for logical thinking....

[marchoctober]

Not at all!

I recommend to go trough QV11 for Devs book by Barry Harmsen & Miguel Garcia.http://www.bitmetric.nl/qlikview-11-for-developers/

[Anonymous]

Thanks. The book is on its way.