topic Re: create a table with "more" text in QlikView

create a table with "more" text

josephinetedesc — Wed, 06 May 2015 13:53:34 GMT

I have a table and the values are correct, but ...

I have been asked if I can produce something more like a printt document - this does seem a silly thing to do however ... that is another discussion.

As an example (shown in the spreadsheet)

a3 and a8 are just "fillers" - useful as explanations, but not really part of the table.

How would I go about doing this ... should I make a text box and then have the table "on top" aligined on the textbox?

Re: create a table with "more" text

rakesh_kumar — Wed, 06 May 2015 15:48:02 GMT

Hi Josephine,

yes these are just like labels and usually they are placed in the dashboard using a text object.

Regards,

Re: create a table with "more" text

josephinetedesc — Wed, 06 May 2015 22:25:33 GMT

Thank Rakesh, but does that mean I cannot just add a "filler" column to a working table?

Re: create a table with "more" text

ToniKautto — Wed, 06 May 2015 22:39:35 GMT

I am not really sure I understand what you are trying to do with the data. Could you provide a sample QVW where you statically show how the data should be presented? This would make it easier to suggest how to accomplish the same from your Excel file.

Re: create a table with "more" text

petter — Wed, 06 May 2015 22:40:22 GMT

You can add a filler column if you like

Re: create a table with "more" text

josephinetedesc — Wed, 06 May 2015 22:52:00 GMT

This is Qlikview Table Location		East		West
year	2013	2014	2013	2014
number	14	15	16	21

but this is what I want:

This is the Ql'kView filler column I want	Location	East		West
	year	2013	2014	2013	2014
Figures should range between 10 and 12	number	14	15	16	21

Re: create a table with "more" text

josephinetedesc — Wed, 06 May 2015 22:53:26 GMT

How do i do this?

Re: create a table with "more" text

ToniKautto — Thu, 07 May 2015 00:59:03 GMT

Attached is an example that take the "comment" and shows it in the popup when you hover over a bar chart for example. Not sure this is exactly what you are looking for, but maybe it can give you an idea of how to process the incoming data to accomplish your requirements.

Re: create a table with "more" text

josephinetedesc — Thu, 07 May 2015 01:30:36 GMT

Thanks Toni

but the problem is that they want it to be like a printed document so it needs to look like the Excel spreadsheet - with the extra column as "discussion etc"

Re: create a table with "more" text

danieloberbilli — Thu, 07 May 2015 03:16:21 GMT

The kind of layout should be easily done with a pivot-table where you have one dimension at the left that groups the next dimension. I always create 2 objects in theses cases: one for the dashboard (clean&tidy) and a second one (could be hidden/minimized) that is for the print-out (with additional information/layout/black/white-colorcode).

E.g. you could have a button underneath your chart called e.g. 'Print-friendly chart' that shows/restores the chart and the user can click the excel-export-icon.

Re: create a table with "more" text

josephinetedesc — Thu, 07 May 2015 05:03:32 GMT

Hi Daniel

thinking out loud ...

the pivot table is fine - it is the columns to the left of the pivot table that I want to organise...

I suppose in Excel I would need to do a copy and then paste values ... then add the "filler" tables to the table.

So maybe it cannot be done in QlikView without either making up another element/field called comment1 and comment2 and then having making up a table.

The other way of a text object would not work cos - as the table grows/shrinks it will get out of synch with the comments ... so maybe your idea of the pivot table is probably correct.

ps not sure how to mark you answer as correct rather than helpful???

Re: create a table with "more" text

ToniKautto — Thu, 07 May 2015 06:35:24 GMT

I switched Daniel's comment to Correct.

As a side note you could always evaluate QlikView NPrinting which allows for a very customized way of doing reports.

Introducing QlikView NPrinting | Qlik

Re: create a table with "more" text

danieloberbilli — Thu, 07 May 2015 06:45:50 GMT

Thanks, Toni

Re: create a table with "more" text

josephinetedesc — Sat, 09 May 2015 14:48:33 GMT

I have been trying to use a pivot table but ... I am having difficulties - I think I may have to go back to the idea of a text box and lining up text

I am not sure what I align... i will try and get an example

Re: create a table with "more" text

josephinetedesc — Tue, 12 May 2015 04:19:45 GMT

so... this is what I want but the figures are just repeated for each line.

I am not sure do I link the 2 tables - or ... should I just do the calculation in another table?

Re: create a table with "more" text

danieloberbilli — Tue, 12 May 2015 04:25:05 GMT

You better post this problem in a new thread as this one is marked as 'solved' and members are not likely to read about your further questions.

Cheers

Daniel