Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
justin_morley
Creator
Creator

Turn off/hide expression column headers in a pivot table

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

4 Replies
Gysbert_Wassenaar

Use a single space as Label for the expression.


talk is cheap, supply exceeds demand
justin_morley
Creator
Creator
Author

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

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


talk is cheap, supply exceeds demand
justin_morley
Creator
Creator
Author

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!