New to Qlik Sense

[#1]

Hi,

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

For example:

CompanyName	Date	Sales
Today	01/01/2016	2500
Tomorrow	01/01/2017	33000
Yesterday	01/01/2018	12354

Now i want this:

A	B	C
Today	01/01/2016	2500
Tomorrow	01/01/2017	33000
Yesterday	01/01/2018	12354

Does somebody know how I can achieve this?

Thans.

[sunny_talwar]

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

[#3]

I think I didn't asked my question correctly.

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

[sunny_talwar]

Is this for QlikSense?

[#5]

Yes this is for Qlik Sense

[sunny_talwar]

May be Reddys310‌ can guide you better with Qlik Sense

[#7]

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.

[simondachstr]

Have a look at the Crosstable & Generic load functionality.

[#9]

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

[reddy-s]

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.