topic Re: remove unwanted headers in QlikView

remove unwanted headers

Tue, 15 Sep 2015 05:02:51 GMT

Dear Experts,

I would like to remove unwanted headers in the below table while using cross table.

I want to remove QWT Budget without deleting in source table. The headers are Office,EmployeeID,2008,2009,2010,2011,2012 by using cross table. how to do like below?

Budget:

CrossTable(Budjettivuosi, BudjetoituMaara, 2)

LOAD Office,

EmployeeID,

2008,

2009,

2010,

2011,

2012

FROM

[..\Developer\Datasources\Budget.xls]

(biff, embedded labels, header is 1 lines, table is Sheet1$, filters(

Replace(1, top, StrCnd(null))

));

Best Regards,

Kyaw

Re: remove unwanted headers

tresB — Tue, 15 Sep 2015 05:10:17 GMT

May be like:

CrossTable(Year, Data, 2)

LOAD Office,

EmployeeID,

[2008],

[2009],

[2010],

[2011]

FROM

[....\Book1.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Re: remove unwanted headers

Tue, 15 Sep 2015 06:42:42 GMT

hi tresesco,

can i know how to filter the unwanted header in cross table step by step?

Regards,

Kyaw

Re: remove unwanted headers

jonathandienst — Tue, 15 Sep 2015 06:46:44 GMT

Without a sample of your spreadsheet, anything more than what tresesco has already said will just be guesswork...

Re: remove unwanted headers

prma7799 — Tue, 15 Sep 2015 06:48:40 GMT

Go to > Tables files

> select files which you want to do changes

>Next

> Enable Transformation Step

> select row which you want to delete

>select Delete Marked Option

> Next

> Finish

Re: remove unwanted headers

Peter_Cammaert — Tue, 15 Sep 2015 06:58:34 GMT

If your QWT Header numbers only one row, it should work as-is by way of the "header is 1 lines" option. Remove the filters(Replace()) option and try again.

The input file is first treated with the options you set in the initial LOAD dialog which contains - amongst others - a header type selection list ("Lines") and an input field to enter the number of header lines. Only then is the pivoting (CROSSTABLE) applied.

Peter

Re: remove unwanted headers

Tue, 15 Sep 2015 07:12:33 GMT

hi qlikview7799,

It work well. thanks for your help.

regards,

Kyaw

Re: remove unwanted headers

prma7799 — Tue, 15 Sep 2015 07:16:15 GMT

Hi Kyaw,

Most Welcome.

Thanks