topic Re: Nprinting : Creating calculated columns in excel in Qlik NPrinting

Nprinting : Creating calculated columns in excel

Anonymous — Mon, 27 Nov 2017 04:37:24 GMT

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.

Re: Nprinting : Creating calculated columns in excel

Anil_Babu_Samineni — Mon, 27 Nov 2017 05:19:54 GMT

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

Re: Nprinting : Creating calculated columns in excel

Chanty4u — Mon, 27 Nov 2017 05:28:49 GMT

you can try excel foramulae

in 3 row

=sum(cell1:cell2) it will work

Re: Nprinting : Creating calculated columns in excel

Anonymous — Mon, 27 Nov 2017 07:40:40 GMT

i tried. it doesnt give me any output.

Re: Nprinting : Creating calculated columns in excel

Chanty4u — Mon, 27 Nov 2017 08:19:28 GMT

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