Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to change column headers to excel column headers?

Hi,

I want to change my column headers to Excel column headers (A, B, C, D)

For example:

CompanyNameDateSales
Today01/01/20162500
Tomorrow
01/01/2017
33000
Yesterday
01/01/2018
12354

Now i want this:

ABC
Today
01/01/2016
2500
Tomorrow
01/01/2017
33000
Yesterday
01/01/2018
12354

Does somebody know how I can achieve this?

Thans.

Tags (1)
9 Replies

Re: How to change column headers to excel column headers?

I guess these two settings are the important ones

Label should be set to None and I would expect that you have labels and wouldn't want to load them as data, so use header size -> line and 1 as the number

Capture.PNG

Not applicable

Re: How to change column headers to excel column headers?

I think I didn't asked my question correctly.

error.png

So know I want, instead of the dates as column headers, the real excel headers

So i want to get as header: "Resultaat, Leningnaam, AT, AU, AV, AW,...

Thanks

Re: How to change column headers to excel column headers?

Is this for QlikSense?

Not applicable

Re: How to change column headers to excel column headers?

Yes this is for Qlik Sense

Re: How to change column headers to excel column headers?

May be Reddys310‌ can guide you better with Qlik Sense

Not applicable

Re: How to change column headers to excel column headers?

error2.png

Do you maybe know how i know can get the value of the %Date (@3, @4) but I don't want to change the @3, @4 because the next time I read another Excel file with the same lay-out I don't want to get errors so I can't use the real date value because in each Excel file the date values will change.

Luminary
Luminary

Re: How to change column headers to excel column headers?

Have a look at the Crosstable & Generic load functionality.

Not applicable

Re: How to change column headers to excel column headers?

I'm using a crosstable already, I've know idea how I can use the Generic load in this situation

reddys310
Honored Contributor II

Re: How to change column headers to excel column headers?

Hi Matei,

sunindia‌ reply is the way to go, if you can generate the script the way sunny has mentioned in Qlikview and then copy the script across to Qliksense and that should work.

Thanks,

Sangram.

Community Browser