Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
No, you can only 'blank' the labels by using a space for the dimension and expression labels