Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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...

8 Replies
Not applicable

Grouping data

Hi, Not able to understand your problem.. Could repharse your question.

- Sridhar

sathishkumar_go
Not applicable

Grouping data

Hi,

You "Amount" field is in which table. Same table or some other table?

some other table means What is the link field for that table?

Better can u attach yr application are give me clear picture?

-Sathish

Not applicable

Grouping data

Hi,

This seems to complex to discribe and due to the data protection act I cannot upload the file. It has customer details in. Thanks for your help though

Not applicable

Re: Grouping data

you scramble you data or send us your sample data with your output

rbecher
Not applicable

Re: Grouping data

How this new category is associated with the other tables?

rahulgupta
Not applicable

Re: Grouping data

Hey Hi,

Please find the attached application for your solution.

Hope this solves your problem.

Regards

Not applicable

Re: Grouping data

Thank you very much for your help. it is a little more complex than this. i'm trying to create an example, please bear with me. once i've got it sorted. i'll show you. In a way it works but I would like the results displayed in a straight table.

Not applicable

Re: Grouping data

Relationship.jpg

This is the relationship between the tables, you can see the amount is in a different table to the new department.

In a straight table can you create more than one calculation? e.g. sum(amount) and the average below the sum