Discussion Board for collaboration related to Creating Analytics for QlikView.
I need to show only the column 'Cost', the columns 'KG' and 'Prom.' are empty. Thanks.
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
in that way it want calculate a total for the expression KG
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