11 Replies Latest reply: Feb 11, 2010 10:33 AM by ashish_w RSS

    Marging two cells in a Table

    ashish_w

      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
          Julian Villafuerte

          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
              ashish_w

              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
              Peter Rieper

              Can you please post a sample file?

              Peter

              • Marging two cells in a Table
                Liron Baram

                hi

                attached is an example

                i hope its helps

                  • Marging two cells in a Table
                    ashish_w

                    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
                    Liron Baram

                    hi

                    here is aonther Example

                    hope it solve your problem

                    if not please attach sample of your data table

                     

                    • Marging two cells in a Table
                      Tim Benoit

                      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
                          Peter Rieper

                          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
                              ashish_w

                              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
                                  ashish_w

                                  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!!