Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to calculate only 1 column in the total

CenterCONSOLIDATED  TOTAL Center  1000Center  1010Center  1900
CostKGPromCostKGPromCostKGPromCostKGProm
TOTAL 1.165.371.999        -             -    457.638.353     -             -    472.287.753     -             -    235.445.893        -             -   
Item 1 1.068.200.953        -             -    422.519.446     -    436.153.156     -    209.528.351        -   
Item 2      97.171.046 2.830 34.330    35.118.907 707 49.648    36.134.597 552 65.503    25.917.542 1.571 16.493

I need to show only the column 'Cost', the columns 'KG' and 'Prom.' are empty. Thanks.

Tags (2)
2 Replies
lironbaram
Honored Contributor II

How to calculate only 1 column in the total

hei

in pivot table the basic rule is it calculate the total for all the expression

but you can change your expression to smoething in the lines of

if(isnull(only(Item))=0,sum(KG))

in that way it want calculate a total for the expression KG

chauhans85
Esteemed Contributor

How to calculate only 1 column in the total

convert to straight table

then go to expression-> seleect no total for

KG' and 'Prom.'

and theen again convert to pivot table

hope this helps

Community Browser