Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

cancel
Showing results for 
Search instead for 
Did you mean: 
benlim_work
Contributor
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
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Chanty4u
MVP
MVP

you can try excel foramulae

in 3 row

=sum(cell1:cell2)    it will work

benlim_work
Contributor
Contributor
Author

i tried. it doesnt give me any output.

Chanty4u
MVP
MVP

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