9 Replies Latest reply: Apr 8, 2014 9:42 AM by Maria Poulsen RSS

    Problems with using two similar datasets in Qlikview

    Maria Poulsen

      Hi!

       

      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 at one time and another sheet with (almost) the same tables and graphs compiled at the other time.

      First I tried to rename the variables in the original daily data set with variableName_daily, so that I knew the difference between the variables from the yearly and the daily data sets.

       

      This worked fine! But then I wanted to make the layout more nice to look at. I wanted to transform the renamed variables in the script using as [ ] function. In the [] I have named the daily variables the same as I have names the yearly data. When I reload I get this error below.

       

      Can't I somehow get the variable names from the two different datasets to appear the same, although the have different initial values (some with _daily on)??

       

      Kind Regards Maria

      error.png

        • Re: Problems with using two similar datasets in Qlikview
          sujeet singh

          Maria i am unable see the pop up box clearly.

          can you please write up the text of it ?

            • Re: Problems with using two similar datasets in Qlikview
              Maria Poulsen

              This is kopied text:

              Syntax error, missing/misplaced FROM:

              STAA_IDAG_DD:

              LOAD rsj_besldato_dd,

                   rsj_anledning_dd,

                   rsj_sted_id_dd,

                   stud_uddramme_id_dd,

                   RETRES_KARAKTER_dd,

                   bedodato_dd,

                   korselsdato_dd,

                   STUDIERETNING_dd as [Studieretning ],

                   EKA_NAVN_dd as [Aktivitetsnavn ],

                   BELASTNING_dd,

                   ADMENHED_dd as [Adm. enhed ],

                   TEORI_PRAKTIK_dd,

                   EKA_aktgrp_dd,

                   aarugenr_dd,

                   ugenr_dd as [Ugenummer ],

                   STAA_dd as [STÅ ],

                   fakultet_dd [Fakultet ]

                   aar_dd as [År ]

                   person_id

              FROM

              [W:\Samlet data\Qlikview_samlet_data\Data_til_wb\STAA\staa_idag_dd.xlsx]

              (ooxml, embedded labels, table is STAA_IDAG_DD)

              STAA_IDAG_DD:

              LOAD rsj_besldato_dd,

                   rsj_anledning_dd,

                   rsj_sted_id_dd,

                   stud_uddramme_id_dd,

                   RETRES_KARAKTER_dd,

                   bedodato_dd,

                   korselsdato_dd,

                   STUDIERETNING_dd as [Studieretning ],

                   EKA_NAVN_dd as [Aktivitetsnavn ],

                   BELASTNING_dd,

                   ADMENHED_dd as [Adm. enhed ],

                   TEORI_PRAKTIK_dd,

                   EKA_aktgrp_dd,

                   aarugenr_dd,

                   ugenr_dd as [Ugenummer ],

                   STAA_dd as [STÅ ],

                   fakultet_dd [Fakultet ]

                   aar_dd as [År ]

                   person_id

              FROM

              [W:\Samlet data\Qlikview_samlet_data\Data_til_wb\STAA\staa_idag_dd.xlsx]

              (ooxml, embedded labels, table is STAA_IDAG_DD)

            • Re: Problems with using two similar datasets in Qlikview
              James Summerson

              You ned to post a bigger screengrab so it's able to be read.

              • Re: Problems with using two similar datasets in Qlikview
                Andrea Zizzo

                I think you forgot the comma the "as" and  "," after the last two fields..

                ...

                fakultet_dd  AS<-- [Fakultet ],<--

                     aar_dd as [År ],<--

                     person_id

                • Re: Problems with using two similar datasets in Qlikview
                  Nizam HM

                  I dont Know Wht u r looking but by seeing ur script these things are missing comma and semicolon

                   

                  Table1:

                  fakultet_dd as [Fakultet ],

                       aar_dd as [År ],

                       person_id

                  FROM

                  [W:\Samlet data\Qlikview_samlet_data\Data_til_wb\STAA\staa_idag_dd.xlsx]

                  (ooxml, embedded labels, table is STAA_IDAG_DD);

                  Table2:

                   

                  fakultet_dd as  [Fakultet ],

                       aar_dd as [År ],

                       person_id

                  FROM

                  [W:\Samlet data\Qlikview_samlet_data\Data_til_wb\STAA\staa_idag_dd.xlsx]

                  (ooxml, embedded labels, table is STAA_IDAG_DD);

                    • Re: Problems with using two similar datasets in Qlikview
                      Maria Poulsen

                      I have corrected the script now - see below. But I still cant get Qlikview to show different pivot tables with

                      - yearly data: variables fakultet and aar

                      versus

                      - daily data: variables fakultet_dd and aar_dd

                       

                      SET ThousandSep='.';
                      SET DecimalSep=',';
                      SET MoneyThousandSep='.';
                      SET MoneyDecimalSep=',';
                      SET MoneyFormat='kr. #.##0,00;kr. -#.##0,00';
                      SET TimeFormat='hh:mm:ss';
                      SET DateFormat='DD-MM-YYYY';
                      SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';
                      SET MonthNames='jan;feb;mar;apr;maj;jun;jul;aug;sep;okt;nov;dec';
                      SET DayNames='ma;ti;on;to;fr;lø;sø';

                      STAA_KUM:
                      LOAD PERSON_ID,
                          
                      rsj_besldato,
                          
                      rsj_anledning,
                          
                      rsj_lbnr,
                          
                      rsj_ress_staa,
                          
                      rsj_res_id,
                          
                      rsj_sted_id,
                          
                      stud_uddramme_id,
                          
                      rsj_uddelement_id,
                          
                      RETRES_KARAKTER,
                          
                      bedodato,
                          
                      staa_id,
                          
                      korselsdato,
                          
                      STUDIEORDN_ID,
                          
                      STORDKOD,
                          
                      STUDIERETNING as Studieretning,
                          
                      EKA_KODE,
                          
                      EKA_NAVN as Aktivitetsnavn,
                          
                      BELASTNING,
                          
                      ADMENHED as [Adm. enhed],
                          
                      TEORI_PRAKTIK,
                          
                      EKA_aktgrp,
                          
                      aarugenr as Ugenummer,
                          
                      ugenr,
                          
                      STAA as [STÅ],
                          
                      fakultet as Fakultet,
                          
                      aar as [År]
                      FROM
                      [QV filer til STAA\STAA_KOMMULERET.QVD]
                      (
                      qvd);

                      STAA_IDAG_DD:
                      LOAD rsj_besldato_dd,
                          
                      rsj_anledning_dd,
                          
                      rsj_sted_id_dd,
                          
                      stud_uddramme_id_dd,
                          
                      RETRES_KARAKTER_dd,
                          
                      bedodato_dd,
                          
                      korselsdato_dd,
                          
                      STUDIERETNING_dd as [Studieretning ],
                          
                      EKA_NAVN_dd as [Aktivitetsnavn ],
                          
                      BELASTNING_dd,
                          
                      ADMENHED_dd as [Adm. enhed ],
                          
                      TEORI_PRAKTIK_dd,
                          
                      EKA_aktgrp_dd,
                          
                      aarugenr_dd,
                          
                      ugenr_dd as [Ugenummer ],
                          
                      STAA_dd as [STÅ ],
                          
                      fakultet_dd as [Fakultet ],
                          
                      aar_dd as [År ],
                          
                      person_id
                      FROM
                      [W:\Samlet data\Qlikview_samlet_data\Data_til_wb\STAA\staa_idag_dd.xlsx]
                      (
                      ooxml, embedded labels, table is STAA_IDAG_DD);