Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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