topic invoice form in QlikView

invoice form

Anonymous — Mon, 05 Dec 2011 15:05:08 GMT

is any way to generate invoice form ...all datas in excel ...i know its possible in crystal report..but i want in qlikview... pls find attachment below

invoice form

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 15:14:41 GMT

Hi,

There's no simple way to get this since QlikView does export to excel but object by object, and the whole object, not a part of it. You can create a report and a hidden sheet with all the required objects and properly formatted to fit perfectly in the paper, and print it in PDF or in paper.

You can create a macro as well, so you have a template and paste in Excel cells the contents from different dimensions or expressions.

Hope that gives you an idea.

Miguel

invoice form

Anonymous — Mon, 05 Dec 2011 15:24:05 GMT

where to fit ...which object i want to chooose for example like tablebox or pivot table

invoice form

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 16:16:16 GMT

Hi,

That will depend on your requirements. Go to the Reports menu, add a new one and make some tests with the different objects you already have, but you will likely have to duplicate them, and leave one as they are to be displayed on screen, and modify the other to fit in the report (smaller fonts, different colors, etc).

Regards.

Miguel