Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner
Partner

set analysis pivot table column presentation

hi,

i want to represent the last column "additional sales" like it is showed in the table. A rest of sales per custumer (target-control), in case there is no control, then it shall be "0". Same for the Target row with no control for the Variant.

testtable.png

test data attached

felipe

   

4 Replies
settu_periasamy

May be try

=[sales per customer]-Above([sales per customer])

ecolomer
Master II
Master II

Is this?

p_sales.png

felcar2013
Partner
Partner
Author

perfecto, gracias

ecolomer
Master II
Master II

Marca, por favor, la respuesta correcta y cierras el hilo.

Gracias.

Saludos,

Enrique Colomer