Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

removing the label row in a pivot table

Hi,

I have a pivot table A in the following format:

A  B  C  D

1   2   3  4

Is there a way way i can remove the tob label row form the pivot table so that the table should look like:

1   2   3   4

4 Replies
er_mohit
Master II
Master II

Go to this link

http://community.qlik.com/thread/70956

or the alternative is that you can put space in label column for doing this column name can't appear but the blank row is appear

Not applicable
Author

try to use

rowno() as key

or try

recno() as key     in your table in script

example--

load * where key>=2;


data:

load

a,

b,

c,

rowno() as key

from table;

Not applicable
Author

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, you can only 'blank' the labels by using a space for the dimension and expression labels


talk is cheap, supply exceeds demand