topic Re: Insert from excel, month issue calendar in QlikView

Insert from excel, month issue calendar

Anonymous — Tue, 11 Oct 2016 08:16:07 GMT

hi, i try to insert table files from excel.

how can i link the months in my excelfile to my calendar?

in each month there is a number value that show the sum for that month.

the other tables that i have linked in earlyer has a datefield so i used the %DateKey, but i dont know how to connect the month without getting a script error Field names must be unique within table.

left join

LOAD Kommune,

F2,

Stasjon,

F4 as MålepunktnavnTemp,

normalperiode,

Jan,

Feb,

Mar,

Apr,

Mai,

Jun,

Jul,

Aug,

Sep,

Okt,

Nov,

Des,

sum

FROM

(ooxml, embedded labels, header is 2 lines, table is [01 Østfold]);

Re: Insert from excel, month issue calendar

JaMajka1 — Tue, 11 Oct 2016 08:26:13 GMT

Hello,

try to use corsstable() function in your script - months will become one regular dimension as if they were in rows not in columns. https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/ScriptPrefixes/crosstable.htm

Maria

Re: Insert from excel, month issue calendar

marcus_sommer — Tue, 11 Oct 2016 08:40:46 GMT

Load your excel with The Crosstable Load and afterwards you could convert your month with makedate() to a date.

- Marcus