topic Re: Table Merging In Script in QlikView

Table Merging In Script

Thu, 20 Sep 2012 08:59:47 GMT

I'm loading data into my solution as in the below:

// Status table

Status:

Load * Inline

[Category

In Progress

Awaiting Initial Audit Check

Awaiting Start Date

Start Date Arranged - Contract to be issued

Awaiting Signed Contract

Awaiting Final Audit Check

Awaiting Signed Tracking Form

Complete

On Hold / Withdrawn];

// Overview Table

CorporateOverview:

LOAD

[Business Unit],

[In Progress],

[Awaiting Initial Audit Check],

[Awaiting Start Date],

[Start Date Arranged - Contract to be issued],

[Awaiting Signed Contract],

[Awaiting Final Audit Check],

[Awaiting Signed Tracking Form],

[Complete],

[On Hold / Withdrawn],

[Total]

FROM $(vSpreadName) (ooxml, embedded labels, table is 'Some Name'')

where RowNo()<12;

Once I've got the data, is it possible to create a new table with something like the below:

Business Unit StatusType Value

1 In Progress 50

1 Complete 20

etc

This would give me the axes I need to draw a graph I'm struggling to create at the minute.

Thanks

Re: Table Merging In Script

giakoum — Thu, 20 Sep 2012 09:10:09 GMT

Hope attached example helps!

Re: Table Merging In Script

Thu, 20 Sep 2012 09:39:59 GMT

That is absolutely superb, thanks Ioannis! I thought it must've been a simple solution. For those that can't open the spreadsheet, Ioannis' solution is to apply a CrossTable() function.

Re: Table Merging In Script

Thu, 20 Sep 2012 10:33:26 GMT

I actually have another question re: the crosstable function. It works perfectly, except for the fact all the rows in the Status column are prefixed with the name of the table. That isn't an issue in your test app, because you've only got one table.

Any ideas?

Re: Table Merging In Script

giakoum — Thu, 20 Sep 2012 10:34:39 GMT

Are you using Qualify command somewhere in your script?

A sample application would help.

Re: Table Merging In Script

Thu, 20 Sep 2012 10:36:45 GMT

Once again, you've got it. Forgot I had a Qualify statement above the table import, moved the table and I'm in business. Thanks Ioannis.