Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

marius_larsen
Not applicable

Insert from excel, month issue calendar

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]);

2 Replies
jamajka1
Not applicable

Re: Insert from excel, month issue calendar

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

marcus_sommer
Not applicable

Re: Insert from excel, month issue calendar

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

- Marcus