topic Re: Partial sum is zero in Pivot Table in QlikView

Partial sum is zero in Pivot Table

Mon, 23 Jun 2014 10:13:24 GMT

Hi Friends

Why partial sum for "Total Sale" is 0 ?

Re: Partial sum is zero in Pivot Table

ashfaq_haseeb — Mon, 23 Jun 2014 10:15:51 GMT

Hi,

go to chart properties --> Expression tab --> select sum of rows in total mode

Regards

ASHFAQ

Re: Partial sum is zero in Pivot Table

Mon, 23 Jun 2014 10:33:24 GMT

Hi Mohammed

Total Mode is disable (grey) in Expression tab.

Re: Partial sum is zero in Pivot Table

ashfaq_haseeb — Mon, 23 Jun 2014 10:42:46 GMT

try below

=(Sum({<YearMonth=YearMonth>} Foroosh))*(sum(Fe))

Regards

ASHFAQ

Re: Partial sum is zero in Pivot Table

MayilVahanan — Mon, 23 Jun 2014 11:21:31 GMT

Try like this

= If(RowNo() = 0 or IsNull(RowNo()), Num(Sum(Aggr(Sum({<YearMonth={"=YearMonth"}>} Foroosh)* (Fe),CodeKala)),'###,###,###.#0'), Sum({<YearMonth={"=YearMonth"}>} Foroosh)* (Fe))

Hope it helps

Re: Partial sum is zero in Pivot Table

Mon, 23 Jun 2014 11:31:09 GMT

Thanks , Dear Mayil.