Discussion Board for collaboration on QlikView Scripting.
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.
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]))
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:
Hope this helps.
Your formula given did not work exactly.
Also, just to clarify, we only buy the FEEMS and the ITEM CODE's is out finished product that we build.
Any feedback on my last reply.