topic Re: Ignoring dimension for calculating sum in QlikView

Ignoring dimension for calculating sum

Fri, 07 Mar 2014 15:14:52 GMT

I have the following chart in QV. Line , Date , Type and Product are the dimensions while Qty and Type Total are the expressions.

In the chart Qty is being calculated correctly using the formula : sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'} >} Qty)

But I am not able to get the Type Total correctly. I want the Type total to be calculated ignoring the product column. Like in the following chart for X1 , 04/08/2013 and Type C - Type Total should be 45 in both the rows.

Line	Date	Type	Product	Qty	Type Total
X1	4/8/2013	A	P1	20	20
		Total			20
		B	P1	30	30
		Total			30
		C	P1	15	45
		C	P2	30	45

Re: Ignoring dimension for calculating sum

Gysbert_Wassenaar — Fri, 07 Mar 2014 15:17:03 GMT

Try sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'} >} TOTAL <Line,Date,Type> Qty)

Re: Ignoring dimension for calculating sum

Fri, 07 Mar 2014 15:23:04 GMT

Thanks! it added one more row and I was able to hide that using Suppress Null check box from dimension

Re: Ignoring dimension for calculating sum

SunilChauhan — Fri, 07 Mar 2014 15:23:09 GMT

Try this

sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'},ProductType = >} Qty)

hope this helps