topic Re: Problem in SubTotal in straight table in QlikView

Problem in SubTotal in straight table

Wed, 21 Jan 2015 11:03:21 GMT

Dear Experts,

There is problem with subtotal in a straight table as shown in below table.

The last column expression does not evaluate subtotal for column F2.

Please help us to get correct result for subtotal.

Please refer attached file.

Regards

Nitin K

F1	F2	=SUM(F3+ (F4/F5) )	=SUM(F5)	=SUM((F3+ (F4/F5) ) * F5)	= SUM((F3+ (F4/F5) ) * F5) / SUM((F3+F4)*F5)
A	1.1	2.75	4	11.00	0.55
A	1.2	3.80	5	19.00	0.54
A	1.3	4.83	6	29.00	0.54
A	Total	11.38	15	59.00	0.54
B	1.1	2.75	4	11.00	0.55
B	1.3	4.83	6	29.00	0.54
B	Total	7.58	10	40.00	0.54
C	1.1	2.75	4	11.00	0.55
C	1.2	3.80	5	19.00	0.54
C	1.3	4.83	6	29.00	0.54
C	1.4	5.86	7	41.00	0.53
C	Total	17.24	22	100.00	0.54
D	1.2	3.80	5	19.00	0.54
D	1.4	5.86	7	41.00	0.53
D	Total	9.66	12	60.00	0.54

Re: Problem in SubTotal in straight table

robert_mika — Wed, 21 Jan 2015 11:25:47 GMT

Try this:

= SUM(((F3+ (F4/F5) ) * F5) / ((F3+F4)*F5))

Re: Problem in SubTotal in straight table

alexandros17 — Wed, 21 Jan 2015 11:27:59 GMT

Your last expression should be:

= SUM((F3+ (F4/F5) ) * F5 / ((F3+F4)*F5))

let me know

Re: Problem in SubTotal in straight table

Wed, 21 Jan 2015 11:33:46 GMT

Thanks Robert,

Its working

Re: Problem in SubTotal in straight table

Wed, 21 Jan 2015 11:33:56 GMT

Thanks Alessandro,

Its working

Re: Problem in SubTotal in straight table

Wed, 21 Jan 2015 11:57:02 GMT

Dear Robert,

I'm colleague of Nitin, We're evaluating below expression. Could you help to reorganize the equation.

=sum(if(MDC_YEARMONTH_PS >= v_PRE_VER_YEARMONTH and MDC_VERSN_PS = vPrestart_Version and MDC_TYPPS_PS = 'M', MDC_PLAN_VAL_PS + (MDC_PLAN_VAL_PS * v_CONSUM_NORM_PRE)))

/sum({<TO_YEARMONTH={'>=$(v_PRE_VER_YEARMONTH)'},TO_VSNMR={$(vPrestart_Version)}>}TO_FC_QTY)

Thanks

Ashif

Re: Problem in SubTotal in straight table

robert_mika — Wed, 21 Jan 2015 11:59:25 GMT

You are welcome.

Could you mark the answers as Correct ,please?

Re: Problem in SubTotal in straight table

robert_mika — Wed, 21 Jan 2015 11:59:49 GMT

This is more tricky.

Could you post your file?

Re: Problem in SubTotal in straight table

Wed, 21 Jan 2015 12:01:22 GMT

File is more than 300MB. So could not possible. Thats why Nitin created sample file.

Re: Problem in SubTotal in straight table

robert_mika — Wed, 21 Jan 2015 12:14:16 GMT

Sorry Ashif.

This is a little bit too complicated for me yet.

Maybe Allesandro will help