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):
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)
and after drill-down:
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.