topic Problems with using two similar datasets in Qlikview in QlikView

Problems with using two similar datasets in Qlikview

Anonymous — Tue, 08 Apr 2014 11:57:51 GMT

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

Re: Problems with using two similar datasets in Qlikview

sujeetsingh — Tue, 08 Apr 2014 12:00:42 GMT

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

ThornOfCrowns — Tue, 08 Apr 2014 12:11:45 GMT

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

Re: Problems with using two similar datasets in Qlikview

Anonymous — Tue, 08 Apr 2014 12:15:02 GMT

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

(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

(ooxml, embedded labels, table is STAA_IDAG_DD)

Re: Problems with using two similar datasets in Qlikview

sujeetsingh — Tue, 08 Apr 2014 12:17:39 GMT

james is right

Re: Problems with using two similar datasets in Qlikview

Tue, 08 Apr 2014 12:18:52 GMT

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

marcus_malinow — Tue, 08 Apr 2014 12:19:40 GMT

Maria,

it looks like you're missing a semicolon after your first load statement.

Marcus

Re: Problems with using two similar datasets in Qlikview

Anonymous — Tue, 08 Apr 2014 12:43:59 GMT

Now I don't get the error message - but it seems like I am not able to work with two data sets that have the same variable indication. I can see the numbers in the two tables I make (which should have different values) have the same values - so somehow Qlikview can't recognise if the variables comes from the one or the other data set..
The tables below should show not show the same values:

Re: Problems with using two similar datasets in Qlikview

nizamsha — Tue, 08 Apr 2014 12:45:43 GMT

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

(ooxml, embedded labels, table is STAA_IDAG_DD);

Table2:

fakultet_dd as [Fakultet ],

aar_dd as [År ],

person_id

FROM

(ooxml, embedded labels, table is STAA_IDAG_DD);

Re: Problems with using two similar datasets in Qlikview

Anonymous — Tue, 08 Apr 2014 13:42:06 GMT

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

(ooxml, embedded labels, table is STAA_IDAG_DD);