topic Re: How to create empty table (print and fill-in) in QlikView

How to create empty table (print and fill-in)

Mon, 31 Oct 2011 10:53:36 GMT

Hi!

I have a data table that is going to be printed in a report. All in QV native on board tools.

However, I need to have another 5 rows fixed table in the trailer section of each sheet in the report.

The question is now, how to create an empty (for fill in purpose on the printout) 5 rows table?

I could create an empty XLS File, but that does not seem to be very sophisticated. Is there a better solution for my issue.

In other words, can I create a non dynamic table, that is independent from any data, so it should just be the layout!

Thx in advance!

Re: How to create empty table (print and fill-in)

swuehl — Mon, 31 Oct 2011 11:59:08 GMT

Maybe like this?

I used a synthetic dimension to create the rows, with expressions just plain 1. Set TextColor to white() in dimension and expression attributes.

Hope this helps,

Stefan

Re: How to create empty table (print and fill-in)

Mon, 14 Nov 2011 11:58:16 GMT

Thanks you Stefan! You have helped me to get one step further.

However, I have another question: Can I get a column value (it is a Timestamp which ist the very same for each row - distinct delivers one result like 01.01.2010 14:00) into the header or footer section in the printout?

My report currently already utilizes header and footer, as well as Leading-Table, Main DataTable, and the mentioned emtpy 5 Row Table as trailer-table for fill in purpose.

And now I need to get the distnict (timstamp-value), which I already have available as a normal row-value, into the header or the footer section.

Is there any option or trick to do this? Like binding the distincted timestamp-value to a variable that can be accessed in header or footer definition, somehow ?! Or something completely different, probably?!

Re: How to create empty table (print and fill-in)

swuehl — Mon, 14 Nov 2011 12:31:48 GMT

I am not an expert in report creation, but I think you could enter dynamic expressions in the header or footer sections.

For example, try putting

=max(TIMESTAMP)

in one of the footer sections, e.g. centre part. Or calling your variable like =$(vVariable)

Hope this helps,

Stefan

Re: How to create empty table (print and fill-in)

Mon, 14 Nov 2011 13:06:39 GMT

Ah, that could work, but:

My timestamp is a string in the following format: "dd.MM.YYYY HH:mm:ss", hence the max() gets me a "-" as result. I think max(aSrting) does not work.

I guess 'll have to try and find a conversion routine.

EDIT:

Thanks, I got it:

I do not even need a variable: In the footer section a "=Max (myTimestamp)" does the trick already. WOW!

Re: How to create empty table (print and fill-in)

swuehl — Mon, 14 Nov 2011 13:09:31 GMT

try a

=only(TIMESTAMP) if your field is same for each record, it should work.

=maxstring(TIMESTAMP)