Print one P&L per logistic center

[#1]

Hi,

First of all sorry about my english.

I have a list of all my logistic centers and every time i press one of them i get the P&L information. Now i have the challenge of generate a report with one logistic center per page so i can send it to the sales manager.

Is it possible to generate it in a report so i don't have to do i manually?

Thanks so much!!!!!!

[paulyeo11]

Hi Jo

i am not sure what it your actual requirement. May be you are asking how to generate individual report using report menu.

if yes , then you can make use of batch file when batch file is run it will automatic generate all the individual report in PDF file , and you can use the PDF file to send to manager.

what i did is i make the batch file automatic call the QV doc reload and generate the PDF report. and i share the folder with all my sales staff to access the report , it is update daily.

Paul

[#3]

Could you share that batch file?

is that file work with publisher only?

Karthik

[vikasmahajan]

You can design qvw and sending it via email automatically through qlikview:

Steps:

               Create your qvw file.

                Write macro on post reload of qvw

                execute macro through external task like windows schedular

                schdule as per your requirement.

[#5]

How can i make this batch?

[#6]

Hi Vikas!

Thanks for your answer... I've never created a macro in QV or Excel. Can you give me a little more help?

!!

[vikasmahajan]

Hii,

Steps to Create Batch File:

create xyz.bat  in dos prompt of  your qlikview server type following details

"C:\Program Files\QlikView\qv.exe"  /l  /noSecurity  "D:\Qlikview Applications Dir \Email_Distribution.qvw"

EXIT

Following are the steps for scheduling in Windows please refer attached jpg files. This way you can execute your

job as per management requirement timings.

Bye

Vikas