topic Re: Problem with subtotals in a pivot chart in QlikView

Problem with subtotals in a pivot chart

geogou1973 — Tue, 04 Oct 2016 10:23:15 GMT

Hello,

I have the following formulain a pivot chart.

IF(PHASE='PHASE1',sum({<SALES_DATE={'>=$(=start_date)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY),

IF(PHASE='PHASE2',sum({<SALES_DATE={'>=$(=start_date2)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY)))

When i check the show partial sums in the presentation for the field PHASE the totals do not show for the phases.

I think this is happening because i have in the formula if condition and no sum(if...)

How can i convert the formula in order to have the totals for the phase in the top.

I have to mention that i want to show and other subtotals for other fields.

Thank you in advance.

Re: Problem with subtotals in a pivot chart

sunny_talwar — Tue, 04 Oct 2016 10:25:19 GMT

What all your dimensions? Try this:

Sum(Aggr(

IF(PHASE='PHASE1',sum({<SALES_DATE={'>=$(=start_date)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY),

IF(PHASE='PHASE2',sum({<SALES_DATE={'>=$(=start_date2)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY)))

, DimensionNamesHere))

Re: Problem with subtotals in a pivot chart

geogou1973 — Tue, 04 Oct 2016 10:32:15 GMT

It is OK. Thank you very match