topic Subtotal headings in QlikView

Subtotal headings

Wed, 08 Jun 2011 13:14:37 GMT

I am trying to make a table, which looks like the example in the attachment:

I have also included an example of the data. Basically I am trying to include subtotals, which I would like to lay out.

Thanks!!

Subtotal headings

stigchel — Wed, 08 Jun 2011 13:31:20 GMT

Expand the expression (by clicking the '+' sign in front of it) in your qlikview table to edit e.g. the background color. Here you can use the fact that the rowno() propertie of (sub)totals is 0.

=if(rowno()=0,rgb(0,0,255),...)

Subtotal headings

Wed, 08 Jun 2011 13:31:36 GMT

Wouty,

You need to have to have at least 2 Dimensions and Pivot table for such presentation.

Once you have made chart, just go to properties ---Presentation (Just below Dimensions)

Here check box for Partial Sum for desired Dimension and Give name of Subtotal.

Regard

Subtotal headings

Wed, 08 Jun 2011 13:41:41 GMT

nice! I overlooked partial sum!

Re: Subtotal headings

fernandotoledo — Wed, 08 Jun 2011 13:46:44 GMT

You can use a mapping dimension that will work like this:

sales:

Load * inline [

SalesMan, Value

A, 10

B, 15

C, 30

D, 40

];

report_formatting:

Load * inline [

Report, SalesMan

A, A

B, B

C, C

D, D

Total, A

Total, B

Total, C

Total, D

];

In your chart you can use the "Report" dimension and then make the configuration suggested above by Stigchel

Regards,

Fernando