Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove First Row From Pivot Table

Hi,

I have a pivot table without any dimensions, and with a couple of expressions.

I want to remove the first row, where the dimensions labels would have been.

I know that in a straight table I can hide it, but for my needs, it must be a pivot table.

I've attached a .qvw with a simple example.

Thanks!

Picture1.png

Edit: clarification: I do not wish to remove the row 'count of Index', I want to remove the one above it, where the dimensions labels would have been.

11 Replies
Kushal_Chawda

Why you want to remove 1st line? Is it due to zero?

If so you are taking wrong field name in your expression. Field name is Index while you are taking expression as count(index). Field names are case sensitive.

Not applicable
Author

Thanks.

I couldn't replicate it myself, so I just copied what you've uploaded.