topic Re: Party - table plan in QlikView

Party - table plan

jstensig — Thu, 15 Sep 2011 09:00:30 GMT

Hi,

At my job we´re planning a party for approx. 1800 people. In a database we have all data about who is coming and if they bring their partner etc. Also we have assigned info about where each guest has to sit (TableNo).

I have to find a solution on how to make an overview to place on each table, showing information as seen in the example below.

I was thinking of making a report in QlikView and then set the report to loop over TableNo. Can I do this in QlikView ?

Re: Party - table plan

Thu, 15 Sep 2011 12:48:00 GMT

Hi,

something like this could be ok?

U can use trellis dimension also to split the table.

C u,

Stefano.

Re: Party - table plan

jstensig — Thu, 15 Sep 2011 13:14:32 GMT

Hi,

Thank you for replying. I´ve tried to use the Block Chart, but couldn´t make it act the way I want. Meanwhile I´ve found something interesting made by John W.

http://community.qlik.com/message/91009#91009

Right now I think it might be the solution

Party - table plan

Thu, 15 Sep 2011 13:26:52 GMT

Hi,

ok, u have to say if you want a colored pivo table also..

C u,

stefano.

Re: Party - table plan

jstensig — Mon, 19 Sep 2011 14:01:42 GMT

Hi stefano,

Thank you for offering your help.

I´ve attached my solution

1. Pivot table with conditionally formatting

2. 3 straight tables with Company names and color

3. 3 straight tables with names

4. A couple of text objects

5. A Report to make it easy og "good-looking" to print

Regards

jstensig