topic AW:Re: AW:QV Totals wrong in QlikView

QV Totals wrong

Thu, 20 Jan 2011 14:13:01 GMT

Why does QV total this expression wrong? Total sb 23,821,797

Thanks for any help. Sharon.

Fiscal_Year	Fiscal_Period	Fiscal_Week	=Sum({$<Payment_Type={'M','C'},Carrier_Type_Carriers-={'F','2F',' '}, Carrier_Paid_Chk_Date={">=01/02/2010<=01/29/2010"} , Member_Paid_Chk_Date={">=01/02/2010<=01/29/2010"}>} Allowance_Total_Load_Hdr_from_Load_Dtl)
			$21,672,923.03
2010	1	1	$3,025,703.04
2010	1	2	$4,586,765.41
2010	1	3	$5,497,223.87
2010	1	4	$10,712,106.81

AW:QV Totals wrong

Thu, 20 Jan 2011 15:48:07 GMT

Hello Sharon,

check out what kind of Total you are using for this expression. See: chart properties --> expression --> choose the according expr. --> Total Mode

HtH
Roland

AW:QV Totals wrong

Thu, 20 Jan 2011 16:07:22 GMT

Yes, it is set to use the expression total.

AW:Re: AW:QV Totals wrong

Thu, 20 Jan 2011 16:46:41 GMT

Hello again,

if this is wrong, try using "function-Mode" (third radio-button) and choose sum(). May be thats it.

AW:Re: AW:QV Totals wrong

Thu, 20 Jan 2011 17:20:28 GMT

Well, that worked for this extracted example but my actual page has several more dimensions so I added each dimension one by one to this example to see if the total would change and it did not. So now I have two pages with the only diff being one has more expressions (columns) but this column is still diff between the two. I am perplexed.

Sharon.

AW:Re: AW:Re: AW:QV Totals wrong

Fri, 21 Jan 2011 11:16:22 GMT

Hi Addington,


Addington wrote:Well, that worked for this extracted example

thats what I can do for you so far. When adding more dimensions the virtual cube changes of course and I do not know what you are expecting then. For digging deeper: posting an exam app would be helpful. Then we both and the community can figure out more.