Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

pivot table total count 0 & expression issue

Hey Guys,

Have following issues in my pivot table

SHIFTSTART SHIFTEND SHIFTDATE SHIFTWEIGHT HANDLEDQTYPARTNO
S114:0021:4514/01/201312515CRATE
10010CASES
505CASES
TOTAL00

Total gives my 0 ?? Any clues ?

SHIFTSTART SHIFTEND SHIFTDATE SHIFTTOOLWEIGHT HANDLEDQTYPARTNO
S114:0021:4514/01/2013CRANE112515CRATE
10010CASES
505CASES
CRANE 212515CRATE
10010CASES
505CASES

I inserted a new field tool but only want to have the view as below

SHIFTSTART SHIFTEND SHIFTDATE SHIFTTOOLWEIGHT HANDLEDQTYPARTNO
S114:0021:4514/01/2013CRANE112515CRATE
CRANE210010CASES
505CASES

Thanks for helping me out with these issues

1 Reply
Not applicable

Re: pivot table total count 0 & expression issue

current expression used :

=

sum({$<MCH_CODE={"SH*"}>}WEIGHT_HANDLED)

Community Browser