Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

benlim_work
New Contributor

Nprinting : Creating calculated columns in excel

hi everyone, i have a report that shows the daily revenue of fixed columns (last 3 days).

The table in qlikview formula is

Dimension : Type

Dimension : Date

Expression : Sum(Vol)

i would like to create a customized columns on F and G to get the sum and avg for the column C : E that is computed in qlik. how can i do this in nprinting?

level doesnt seems to suit me as i have some computation involve where i cant use table box.

4 Replies

Re: Nprinting : Creating calculated columns in excel

I believe you can do same in Qlikview and then you can work for N Printing to get desired view.

sureshqv
Esteemed Contributor III

Re: Nprinting : Creating calculated columns in excel

you can try excel foramulae

in 3 row

=sum(cell1:cell2)    it will work

benlim_work
New Contributor

Re: Nprinting : Creating calculated columns in excel

i tried. it doesnt give me any output.

sureshqv
Esteemed Contributor III

Re: Nprinting : Creating calculated columns in excel

you need to take the extra cell   and add it in sum and try

Community Browser