Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to add an expression into a pivot table without being divided on columns?

Hi,

I have a pivot table with details for two dimensions: Material in row and Month in column. I'd like to add a new expression in the table independently of the existing one, but not to be split into month detail (see the attachment - Col2). How can I do that without be constrained to add the expression split into months?

Thank you in advance,

Cristina

1 Solution

Accepted Solutions

Re: How to add an expression into a pivot table without being divided on columns?

You'll have to add the expression as a calculated dimension. Perhaps something like =aggr(sum(ind1/(ind2-ind3)),Material)


talk is cheap, supply exceeds demand
1 Reply

Re: How to add an expression into a pivot table without being divided on columns?

You'll have to add the expression as a calculated dimension. Perhaps something like =aggr(sum(ind1/(ind2-ind3)),Material)


talk is cheap, supply exceeds demand
Community Browser