If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I want to change my column headers to Excel column headers (A, B, C, D)
Now i want this:
Does somebody know how I can achieve this?
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
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,...
Is this for QlikSense?
Yes this is for Qlik Sense
May be Reddys310 can guide you better with Qlik Sense
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.
Have a look at the Crosstable & Generic load functionality.
I'm using a crosstable already, I've know idea how I can use the Generic load in this situation
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.