topic Exporting chart to excel in NPrint in QlikView

Exporting chart to excel in NPrint

Wed, 09 Dec 2015 09:05:37 GMT

Hello,

Am spooling this line chart to excel via NPrint. Am using paging and the Date is my keyfield for paging.

What I want to achieve is @ page 01/Nov2015 it should show only 01/Nov/2015 info then @page 02/Nov2015 it should show both for Day 01 and 02 info. And @page 03/Nov2015 it should show Day1,2,3 info. @page for it showed show Day1,2,3,4 info and so on. It shouldnt discard previous days info as the page moves.

Re: Exporting chart to excel in NPrint

Wed, 09 Dec 2015 13:01:04 GMT

could it be nobody is using NPrint?

Re: Exporting chart to excel in NPrint

teiswamsler — Wed, 09 Dec 2015 13:07:38 GMT

hi Emac

Correct me if i am wrong, do you want the out put to been above grafh looping over different set of dates ?

Then make the coorect flags in QV script and loop/cycle over the fields in NPrinting.

/Teis

Re: Exporting chart to excel in NPrint

Wed, 09 Dec 2015 13:27:39 GMT

I didnt get that very well. but its sounds like what i meant.

I wanna export to excel in paging so in excel we have

and you know by default been that Date is my dimension too in the line chart NPrint will just render my chart as one dot. But i want my chart to be continuous. I want my chart to flag previous days into e.g

Page1 [01-Nov-2015]

Page2 [02-Nov-2015]

Page3 [03-Nov-2015]