Discussion Board for collaboration on QlikView Scripting.
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.
F4 as MålepunktnavnTemp,
(ooxml, embedded labels, header is 2 lines, table is [01 Østfold]);
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
Load your excel with The Crosstable Load and afterwards you could convert your month with makedate() to a date.