Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create pie chart?

how can I create pie chart (see to image) with information about number of piece (column TAB1.Piece) for items XY (column TAB2.ITEM) for specific selection of PLACE (column TAB3.Place):
error loading image
where structure of database tables (data sources) is following:

TABLE `TAB1`:
PlaceNo: INT,
ItemNo: INT,
Piece: INT, ...

TABLE `TAB2`:
ItemNo: INT,
Item: VARCHAR, ...

TABLE `TAB3`:
PlaceNo: INT,
Place: VARCHAR, ...

and where details data may be:

TAB1:
PlaceNo ItemNo Piece
1 123 14
1 234 5
...
2 436 100
...

TAB2:
ItemNo Item
123 Abcdefg
234 Qwerty
...
436 Asdfgh
...

TAB3:
PlaceNo Place
1 place01
2 place02
...

and if I would want drill-down pie chart?
First step would be pie chart with information about total number of piece (for all items) for place (see following image),
and second step (after drill-down) would be pie chart with information about number of piece (column TAB1.Piece) for items XY (column TAB2.ITEM) for specific selection of PLACE (column TAB3.Place)
error loading image
and after drill-down:
error loading image
thanks for all tips

PS: Sorry this message would to be in category "QlikView desktop (Developer/Professional/Analyzer", but I have problem with adding message item to that forum category.

0 Replies