topic Re: Grouping Dimensions in a Table in QlikView

Grouping Dimensions in a Table

Anonymous — Thu, 26 Jun 2014 16:31:32 GMT

Hello my QlikView friends I am hoping this is very easy to understand and create. I have an example table pictured below. I want to know how to create the grouped dimension section, with the arrow pointing to it. It is my current understanding that I would have Expressions for Apples and Oranges, summing each. But how do I group those two fields under another calculated dimension? Thank you

Re: Grouping Dimensions in a Table

eduardo_sommer — Thu, 26 Jun 2014 16:59:57 GMT

Create a table, like

Load * inline [

Category, Item

Fruits, Apples

Fruits, Oranges

Vegetables, Tomato

Vegetables, Potato

];

No, you can use the Category as a dimension and pivot it to columns

Eduardo

Re: Grouping Dimensions in a Table

eduardo_sommer — Thu, 26 Jun 2014 17:04:19 GMT

I forgot something: you can also pivot the Item Dimension to a column, under category, and have what you want.

Eduardo

Re: Grouping Dimensions in a Table

its_anandrjs — Thu, 26 Jun 2014 17:31:59 GMT

Simple add one calculated dimension

=If(Match(FruitType,'Apples','Oranges'),'Fruit',

if(Match(FruitType,'Tomoto','Potato'),'Vegetables'))

Note:- I assume FruitType contains(Apples,Oranges,Tomoto,Potato)

Re: Grouping Dimensions in a Table

Anonymous — Thu, 03 Mar 2016 20:56:31 GMT

In a PivotTable upload your data.

Click Category, and then drag until the blue arrow on the column expression

will look like

Click on item and drag down Category until the blue arrow as shown below

will look like