4 Replies Latest reply: Jul 26, 2013 5:45 AM by Justin Morley RSS

    Turn off/hide expression column headers in a pivot table

    Justin Morley

      Hi,

      I'd like to be able to turn off expression column headers in a pivot table.

      I have two expressions, one for a result value, one for a result modifier (e.g. '>' or '<')
      I have one pivoted dimension, Result Type.

      My pivot table looks like this:

       

      Result Type >|      Weight     |       Length    |
      Timepoint    |modifier | value |modifier | value |
      --------------------------------------------------
      1            |         |  10.2 |         | 12    |
      2            |        <|  1    |         | 10.9  |
      3            |         |  3    |         | 11    |


      The column headers for my expressions in this table are largely redundant, and make a complete mess on exporting, I actually want to see this:

       

      Timepoint    |      Weight     |       Length    |
      --------------------------------------------------
      1            |         |  10.2 |         | 12    |
      2            |        <|  1    |         | 10.9  |
      3            |         |  3    |         | 11    |


      I can do this when I only have one expression as such:

       

      Timepoint  |>|Weight |Length |
      --------------------------------------------------
      1            |  10.2 | 12    |
      2            |  1    | 10.9  |
      3            |  3    | 11    |

       

      But adding the extra expression forces the column headers to appear. Is there any way to stop this?

      Thanks for your help,

      Justin

        • Re: Turn off/hide expression column headers in a pivot table
          Gysbert Wassenaar

          Use a single space as Label for the expression.

            • Re: Turn off/hide expression column headers in a pivot table
              Justin Morley

              Hi Gysbert,

              Thanks for the reply. I've already tried this, and it gives me the following:

               

              Result Type >|      Weight     |       Length    |

              Timepoint    |        |        |         |       |

              --------------------------------------------------

              1            |         |  10.2 |         | 12    |

              2            |        <|  1    |         | 10.9  |

              3            |         |  3    |         | 11    |

               

              Which is no different really.

               

              I want to remove the heading altogether like so:

               

              Timepoint    |      Weight     |       Length    |

              --------------------------------------------------

              1            |         |  10.2 |         | 12    |

              2            |        <|  1    |         | 10.9  |

              3            |         |  3    |         | 11    |

               

               

              The reason I need to do this is I need to have a single header row - Timepoint needs to be in the same row as Weight and Length, so when I take it out into another visualisation/data modelling tool, it imports the columns correctly

               

              Thanks,

               

              Justin

                • Re: Turn off/hide expression column headers in a pivot table
                  Gysbert Wassenaar

                  That's not possible in a pivot table. Perhaps you can use a straight table instead. If you have only two values in your Result Type dimension that means you only have to create two expression more. And you can hide the entire header row in a straight table if necessary.

                   

                  Qlikview is not a spreadsheet program, so merging cells is not an available feature. If you need that kind of feature to create the layouts you need you should consider doing the formatting in a spreadsheet program or buying a tool like Nprinting and create your reports with that

                    • Re: Turn off/hide expression column headers in a pivot table
                      Justin Morley

                      Sadly, there are between 0 and Result Types so the straight table is not an option.

                      I think my best bet is to actually merge the cells by using a concatenated single expression (RESULT_MODIFIER & RESULT_VALUE) then write an extension object to do the export which treats them as separate cells.

                      They need to be in separate cells on export because I require the application to which I'm exporting the data to detect the RESULT_VALUE column as numeric.

                       

                      So thanks for your reply. I think the answer is I need to brush up my JavaScript!