topic Sub-Totals? in QlikView

Sub-Totals?

Wed, 09 Nov 2011 10:12:52 GMT

Is there a straight forward way to do this, including the background colours?

In SQL Server I'd get the data using something like this...

GROUP BY

Label1, Label2, MetaData1, MetaData2 WITH ROLLUP

HAVING

GROUPING(label1) = 0

AND (

(GROUPING(label2) = 0 AND GROUPING(MetaData1) = 0 AND GROUPING(MetaData2) = 0)

(GROUPING(label2) = 1 AND GROUPING(MetaData1) = 1 AND GROUPING(MetaData2) = 1)

)

Label 1	Label 2	MetaData1	MetaData2	Expression1
Week1	Run1	Blah	De Blah	2
Week1	Run2a	Foo	Bar	6
Week1	Run2b	Flibble	De Bob	4
Week1	-	-	-	12
Week2	Run3	Wibble	Wobble	5
Week2	Run4	Izzy	Busy	3
Week2	Run5	Ingleburt	Slapdeback	7
Week2	-	-	-	15

I do know how to get an overall summary, but not multiple sub-totals depending on the data.

(I've worked out a slightly hacky way, to get the task complete, now I'm looking to tidy things up and learn the correct way of doing things.)

Cheers,

Mat.

Sub-Totals?

BarbCline — Wed, 09 Nov 2011 16:51:01 GMT

I'm not sure how to get the multiple sub-totals you desire, but I think I can help with the formatting. If you turn on Design Grid (View... Design Grid), you are given additional options with right click over object. Select "Custom Format Cell" to open a design menu.

I know this works for straight tables and pivot tables. (I'm using QV10)

Sub-Totals?

kamalqlik — Thu, 10 Nov 2011 06:48:23 GMT

Hi.....try it out using the partial sum in the presentation tab...

regards

Kamal