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:
Piece: INT, ...
Item: VARCHAR, ...
Place: VARCHAR, ...
and where details data may be:
PlaceNo ItemNo Piece
1 123 14
1 234 5
2 436 100
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.