I want to use two different datasets in Qlikview - that have the same variable names and the difference between the datasets are, that they are compiled at different times of the year (one time a year and daily). I want to create a sheet in a Qlikview application where I show tables and graphs compiled daily and another sheet with (almost) the same tables and graphs compiled yearly.Qlikview failed in loading two different data sets with the same variable names, so therefore I renamed the variabes in the daily data set to have _dd after each variable name.
But I don't think it is nice to have a variable to appear År_dd (week_dd - dd means daily) in a pivot table, so I tried to rename the _dd variables as it can be seen beow. But when I do that, Qlikview can't seem to distinguish between the variables and make identical tables when I use the daily data set and the yearly data set - and it should not!
How can I use two data sets with the same variable names without Qlikview getting confused?
(if I in the script below don't write as [Fakultet] etc. in the "STAA_IDAG_DD", the tables are made just fine - and Qlikview can seperate the daily data fromthe yearly data)
SET MoneyFormat='kr. #.##0,00;kr. -#.##0,00';
SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';
STUDIERETNING as Studieretning,
EKA_NAVN as Aktivitetsnavn,
ADMENHED as [Adm. enhed],
aarugenr as Ugenummer,
STAA as [STÅ],
fakultet as Fakultet,
aar as [År]
[QV filer til STAA\STAA_KOMMULERET.QVD]
STUDIERETNING_dd as [Studieretning ],
EKA_NAVN_dd as [Aktivitetsnavn ],
ADMENHED_dd as [Adm. enhed ],
ugenr_dd as [Ugenummer ],
STAA_dd as [STÅ ],
fakultet_dd as [Fakultet ],
aar_dd as [År ],
(ooxml, embedded labels, table is STAA_IDAG_DD);