topic Turn off/hide expression column headers in a pivot table in QlikView

Turn off/hide expression column headers in a pivot table

justin_morley — Fri, 26 Jul 2013 08:31:13 GMT

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 — Fri, 26 Jul 2013 09:19:40 GMT

Use a single space as Label for the expression.

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

justin_morley — Fri, 26 Jul 2013 09:28:39 GMT

Hi Gysbert,

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

Result Type >| Weight | Length |

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

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 — Fri, 26 Jul 2013 09:31:12 GMT

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 — Fri, 26 Jul 2013 09:45:27 GMT

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!