8 Replies Latest reply: Jun 1, 2011 4:29 AM by Maria Martineau RSS

    Grouping data

      Hello everyone,

       

      I've got some data where there are 4 categories but want them to be split into 3 per category when reporting in Qlikview. The four categories are as follows:

       

      EAD

      CAD

      FRT

      EPD

       

      I have the type of products

      Apples

      Grapes

      Pears

      Bananas

      Carrots

      Peas

      Peppers

      Beef

      Sausage

      Lamb

      Chicken

      Eggs

       

      I would like the categories to be:

       

      EAD - Fruit

      EAD - Veg

      CAD - Fruit

      CAD - Veg

      FRT - Meat

      FRT - Veg

      EPD - Meat

      EPD -  Fruit

      EPD - Veg

       

      ect....

       

       

       

       

      I've created a table where the categories should match the product

       

       





























































































































       

      CategoryProductNew Category
      EADApplesEAD - Fruit
      EADGrapesEAD - Fruit
      EADPearsEAD - Fruit
      EADBananasEAD - Fruit
      EADCarrotsEAD - Veg
      EADPeasEAD - Veg
      EADPeppersEAD - Veg
      EADBeefEAD - Meat
      EADSausageEAD - Meat
      EADLambEAD - Meat
      EADChickenEAD - Meat
      EADEggsEAD - Meat
      CADApplesCAD - Fruit
      CADGrapesCAD - Fruit
      CADPearsCAD - Fruit
      CADBananasCAD - Fruit
      CADCarrotsCAD - Veg
      CADPeasCAD - Veg
      CADPeppersCAD - Veg
      CADBeefCAD - Meat
      CADSausageCAD - Meat
      CADLambCAD - Meat
      CADChickenCAD - Meat
      CADEggsCAD - Meat

       

      ect....

       

       

      so instead of getting a total I can break it down in to 'new categories' I have done this but I still get the total of EAD and not the individual total of EAD.

       

      I have the dimension of New category and the expression of =sum(amount) thinking that it would total all the new categories but does not.

       

      hopefully someone could help and sorry if I have made it more complicated than it sounds...