topic Marging two cells in a Table in QlikView

Marging two cells in a Table

Wed, 03 Feb 2010 15:39:51 GMT

I want to merge multiple cells in QlikView table.

e.g ID and Sales are two columns and Sales is divided into 2.

ID Sales

Last week | This Week

1. 12 | 12

Does anyone know how to do this?

Any pointers on this would be of great help.

Thanks in advance,

Ashish

Marging two cells in a Table

villafuerte — Wed, 03 Feb 2010 16:00:21 GMT

Hi,

I'm not sure if it is what you want, but if you want to merge 2 fields form your datasource into only 1 field in QV what you can do is to join them in the load script. For example:

LOAD

....

ID & '/' & Sales as IdSales,

....

That way both together will become one filed in QV.

Correct me if I misunderstood your question

Cheers

Marging two cells in a Table

prieper — Wed, 03 Feb 2010 16:00:28 GMT

Can you please post a sample file?

Peter

Marging two cells in a Table

Thu, 04 Feb 2010 06:43:00 GMT

Hi,

Thanks for quick reply.

No. I don't want to merge two fields from the data source, instead if there are two fields coming from LOAD script, i want them to show as two different columns in table. However I want to show a combined header for those two columns above their actual header as i have specified in the original post.

I hope this clarifies what I want to do.

Thanks,

Ashish.

Marging two cells in a Table

Thu, 04 Feb 2010 07:14:30 GMT

Hi,

Thanks for quick reply.

Herewith I am attaching a sample file for reference. The file is an excel sheet.

I hope this file will clarify.

Thanks in advance,

Ashish.

Marging two cells in a Table

lironbaram — Thu, 04 Feb 2010 09:05:41 GMT

attached is an example

i hope its helps

Marging two cells in a Table

Thu, 04 Feb 2010 12:42:23 GMT

Actually I got what you are trying to say. Here, in this example, we have data in one column for current week and last week and depending on the value in the week column we bifurcate it as Current week and Last week.

But what I have is the data for current week, last 4 weeks and last year's week are in different columns. And they are calculated for every week, I mean each row corresponds to data aggregated for current week, last 4 week and last year's week corresponding to say Articles like Sales and Income. In that case I won't be able to apply same logic as you have specified in the example.

Thanks,

Ashish

Marging two cells in a Table

lironbaram — Thu, 04 Feb 2010 21:16:15 GMT

here is aonther Example

hope it solve your problem

if not please attach sample of your data table

Marging two cells in a Table

Thu, 04 Feb 2010 21:49:04 GMT

You could try putting a text box over the top of the two columns. The text box would contain the group heading, in your example the word, "Sales".

Marging two cells in a Table

prieper — Thu, 04 Feb 2010 23:01:06 GMT

Am still not clear, what the OP wants? If the data is to be loaded once, there is already a working solution. If it is supposed to load this file each week, there need to be an identifyer for the date, which may either be extracted from the filename, any other field from the Excel or as a kind of function of TODAY(), like WEEKSTART(TODAY()). The other dates might be calculated mathematically from this.

Peter

Marging two cells in a Table

Fri, 05 Feb 2010 09:45:59 GMT

Please find attached the sample data herewith.

Like Last Week Review, we will have Last 2 week Review 4 week review and so on..

Marging two cells in a Table

Thu, 11 Feb 2010 15:33:34 GMT

For the option of attaching text box at the top of the pivot table - In pivot table, dimensions are locked and scrolling is available for expressions so that dimension is visible for extreme right columns. But if I attach text box at the top and scroll then text box will be as it is and below columns will get changed or can i link text box scrolling to that of the table?

For using cross table - In cross table what happens is, all columns becomes rows. and only one expression we add to expression list. For giving a common label to two or more columns we go on adding the various dimensions as calculated expressions for the levels for which we want to add common labels.

However now, for some metrics which are variance of others in table, i don't have control on showing subtotals at the top/bottom.

Is there any solution to this? or not possible at all.

Please reply. It is urgent!!