topic Re: Create a Grouping Table in QlikView

Create a Grouping Table

Tue, 04 Mar 2014 22:56:36 GMT

I have a table of many records, of stock movments, I whanted to create a Table Object witch grups records by Reference, but avereges or sums some numeric columns, how can I do that?

Re: Create a Grouping Table

swuehl — Tue, 04 Mar 2014 23:02:06 GMT

Just use a straight table chart with dimension Reference and appropriate expressions, like

=avg(FIELD)

=sum(FIELD)

Re: Create a Grouping Table

Tue, 04 Mar 2014 23:07:55 GMT

But I don't whant a Chart, I whanted a Table Object with Records..

Re: Create a Grouping Table

swuehl — Tue, 04 Mar 2014 23:09:34 GMT

If you want to group your records and calculate aggregates, you do want a chart.

Re: Create a Grouping Table

stevedark — Tue, 04 Mar 2014 23:26:12 GMT

It's a strange quirk of QlikView that to get a table with calculations in you need to create a chart, and then tell that chart to be of type Straight Table (or Pivot table).

When you create a chart you will see a number of different chart options (Bar, Line, Pie) on the General tab. The bottom right one is Straight Table.

If you create a Table Box then no calculations can be done and only distinct values from the data model will be shown.

Hope that helps,

Steve

Re: Create a Grouping Table

Anonymous — Wed, 27 Aug 2014 09:54:24 GMT

Hi All,

Is there a way to group column headers like this in PIVOT TABLE?

Defect Details		Test Execution
Tester	Defect Count	Assigned To	Passed	Failed

thanks,

Prakash

Re: Create a Grouping Table

stevedark — Thu, 28 Aug 2014 06:03:20 GMT

In short, no, unfortunately not. You will need to have columns headed Defect Tester and Test Assigned To etc.

Steve