Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
spijatida
Contributor III
Contributor III

Drilling down from sold items into further detail

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

1 Solution

Accepted Solutions
marchoctober
Creator
Creator

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.

View solution in original post

4 Replies
marchoctober
Creator
Creator

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.

spijatida
Contributor III
Contributor III
Author

Thanks..

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

marchoctober
Creator
Creator

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/

spijatida
Contributor III
Contributor III
Author

Thanks. The book is on its way.