0 Replies Latest reply: Oct 8, 2010 5:15 AM by JurajChovan RSS

    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.