topic Re: Renaming fields in a crosstable in QlikView

Renaming fields in a crosstable

chiso_chiso — Tue, 21 Oct 2014 09:00:57 GMT

Gurus,

I used the attached sample to combine my headers which were in two rows of my excel sheet. Apparently, I need to rename some of my headers in both rows.

Can someone please guide.

Re: Renaming fields in a crosstable

jpenuliar — Tue, 21 Oct 2014 09:04:10 GMT

Hi,

Please see image, enter you new Label at the highlighted textbox

Re: Renaming fields in a crosstable

chiso_chiso — Tue, 21 Oct 2014 09:11:37 GMT

Thanks Jonathan, is there a way of renaming each or individual columns that make up the head1 and head2?

Re: Renaming fields in a crosstable

jpenuliar — Tue, 21 Oct 2014 09:13:07 GMT

I was thinking, you could have done it at the LOAD SCRIPT in the first place to avoid renaming the Labels.

Re: Renaming fields in a crosstable

chiso_chiso — Tue, 21 Oct 2014 09:16:17 GMT

Jonathan, would you kindly guide as an example, I keep getting errors. Thanks

Re: Renaming fields in a crosstable

Anonymous — Tue, 21 Oct 2014 09:23:40 GMT

If you want to change the name of head1 , head 2 etc then you use

LOAD

head1 as NewHead1,

head2 as NewHead2

If you want to change the values Machinery, Metal etc I would recommend you to look into the ApplyMap-function.

Kind regards

Niklas

Re: Renaming fields in a crosstable

jpenuliar — Tue, 21 Oct 2014 09:24:33 GMT

hmmm, in your script where you have

S1:

LOAD

atr,

if(Data='',Previous(Data),Data) as head1....

Left join(S1)

LOAD

atr,

Data as head2...

you could just replace Head1/Head2 with the field Name you want.

Re: Renaming fields in a crosstable

jpenuliar — Tue, 21 Oct 2014 09:42:57 GMT

I Agree

Regards,