topic Re: Pivot Table Totals - Incorrect in QlikView

Pivot Table Totals - Incorrect

Fri, 20 Sep 2013 07:32:57 GMT

I have a problem with totals on a pivot table. The total should show 10,000 , but appears blank. Below is a screen shot of the pivot table.

My formula is as follows for JHB - PO:

if([Component Code] = [ITEM CODE], sum(TOTAL([Loc Qty on PO])))

Under the total mode i've tried both Expression Total ans SUm, the result is still zero.

Your help would be appreciated.

kind regards

Nayan

Re: Pivot Table Totals - Incorrect

swuehl — Fri, 20 Sep 2013 09:24:43 GMT

In your total line, the conditon [Component Code] = [ITEM CODE] is ambiguous, so QV can't evaluate to TRUE.

I am not really sure what you are trying to achieve, but maybe this works for you:

sum(TOTAL if([Component Code] = [ITEM CODE], [Loc Qty on PO]))

Re: Pivot Table Totals - Incorrect

Fri, 20 Sep 2013 10:12:17 GMT

Hi Swuehl

Thank you for replying. Your formula did not work exactly.

The table above is part of a buying template (see below)

When we buy we look at the actual components sold .

The totals figures you see are totals of FEEMS. So when we buy, we look at the totals . for JHB - PO , the total does not appear which makes it difficult (more awkward) to work out stock required.

By the way:

PO stands for Purchase Order
The figures are all multiplied by component qty. So for eg, Sales for FBCP12 in May-13 is actually 10. Therefore the sales of component (FEEMS) is 20.

Hope this helps.

Your formula given did not work exactly.

kind regards

Nayan

Re: Pivot Table Totals - Incorrect

Fri, 20 Sep 2013 10:31:04 GMT

Hi Swuehl

Also, just to clarify, we only buy the FEEMS and the ITEM CODE's is out finished product that we build.

kind regards

Nayan

Re: Pivot Table Totals - Incorrect

Wed, 25 Sep 2013 12:53:18 GMT

Hi Swuehl

Any feedback on my last reply.

Kind regards

Nayan