Straight table with secondary titles - Qlik Community

tinkerz1 · ‎2015-07-22

Hi,

This maybe an odd question, as I have a commentry box which has alot of text in it and then alot of smaller dimensions where the text is only 8 - 10 characters but alot of them, how can I present a table like this:

| Commentry A | Commentry B

| ssssssssssssssssssssssssssssssssssss | ttttttttttttttttttttttttttttt

| Commentry A | Commentry B

| ssssssssssssssssssssssssssssssssssss | ttttttttttttttttttttttttttttt

etc

I think I will need one row heading for the dimensions, but for the commentry I think it would look better on each line.

Or it could look like this: with 2 title rows then the text below. with some backgound shading on alternative lines

| Commentry A | Commentry B

| ssssssssssssssssssssssssssssssssssss | ttttttttttttttttttttttttttttt

| ssssssssssssssssssssssssssssssssssss | ttttttttttttttttttttttttttttt

Any solution to this, its down to long commentry.

Thanks,

Neil.

qumniusomnius · ‎2015-07-22

can you make an example how the table should look in excel? this is too unreadable

tinkerz1 · ‎2015-07-22

Hi,

I have attached an excel spreadsheet that I hope explains it.

qlikviewwizard · ‎2015-07-22

Hi Tinkerz1

Please use the below script and check the attached file.

Hope this will help you.

Table:

LOAD [Issue - Owner],

[Issue - ID],

[Issue - Priority],

[Issue - Status],

[Issue - Title],

[Action - ID],

[Action - Priority],

[Action - Status],

[Action - Title]

FROM

[straight table format.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 1))

));

tinkerz1 · ‎2015-07-22

I am sorry I can not open the qvw as I am on the free version.

Also I dont have a problem loading the data, the issue is when I load from excel in this format

Table:

LOAD [Issue - Owner],

[Issue - ID],

[Issue - Priority],

[Issue - Status],

[Issue - Title],

[Action - ID],

[Action - Priority],

[Action - Status],

[Action - Title],

[Issue - Desc.]

[Issue - Comments]

[Action - Description]

[Action - Comments]

FROM

[straight table format.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 1))

));

These dimesions are large blocks of text and I want them in a table, but underneath the other dimesions so I can spread them out

[Issue - Desc.], [Issue - Comments], [Action - Description], [Action - Comments]

qlikviewwizard · ‎2015-07-22

Hi Tinkerz1

Please uncheck the option as shown in picture for the objects.

Let me know if you have any issues.

tinkerz1 · ‎2015-07-22

Hi,

I have posted the spreadsheet again with a raw data tab that will be upload into QV.

Then an output tab, this is the style for the QV table after the LOAD.

Hope this explains it.

saurabh5 · ‎2015-07-22

hi Neil,

I had a similar situation, in order to handle that we created 2 straight table, with the second table below the other table and the first table having 100% transparency and adjusted it such a way that the sequence is 1 row of the first table is followed by 1 row of the second table , but its not an ideal solution.

qlikviewwizard · ‎2015-07-22

Did you load the excel data? If yes, please upload the QV application. Thank you.

qlikviewwizard · ‎2015-07-22

Can you give desired output in excel file. Thanks.