topic Re: Inline dates and imported information in QlikView

Inline dates and imported information

Anonymous — Wed, 23 Apr 2014 11:57:40 GMT

Hi guys,

I’ve got a number of fields which contain dates

Expected documents received
Expected documents processed
Expected documents sent

I wanted to create myself a bit of an upcoming work chart so I put in a set of inline dates as well to compare.

I then wanted to count the information dates against the inline dates so that I could see what work I had to complete and when but it just totals the information dates. Document attached

Can anyone help?

Re: Inline dates and imported information

whiteline — Wed, 23 Apr 2014 12:28:13 GMT

Hi.

You have no relation between the inline dates and the expected dates.

Re: Inline dates and imported information

Anonymous — Wed, 23 Apr 2014 12:47:05 GMT

I've not had any experience with linking tables, i'd appreciate if you could point me in the right direction if you wouldn't mind?

Re: Inline dates and imported information

whiteline — Wed, 23 Apr 2014 17:54:10 GMT

Hi.

The right direction is reference manual.

QV links fields with the same names automatically.

You'd better also decide/describe the data model that you need.

Re: Inline dates and imported information

its_anandrjs — Wed, 23 Apr 2014 17:58:12 GMT

You have to decide and make Master calendar for the application and on the master calendar from which date you have to connect decide then join the date with same name.

Re: Inline dates and imported information

Anonymous — Fri, 25 Apr 2014 11:57:23 GMT

Basically all i need is list to say for example

Date	Milestones
01/01/2014	1
02/01/2014	0
03/01/2014	0
04/01/2014	0
05/01/2014	0
06/01/2014	0
07/01/2014	0
08/01/2014	1
09/01/2014	0
10/01/2014	0
11/01/2014	0
12/01/2014	0

I've looked at master calendars and joins but cannot seem to figure it. All i get is the following

Date	Milestones
01/01/2014	3
02/01/2014	3
03/01/2014	3
04/01/2014	3
05/01/2014	3
06/01/2014	3
07/01/2014	3
08/01/2014	3
09/01/2014	3
10/01/2014	3
11/01/2014	3
12/01/2014	3

It just calculates all the info because the tables arent properly joined

Re: Inline dates and imported information

whiteline — Sat, 26 Apr 2014 08:56:57 GMT

Hi.

Actually, nothing has changed:

"The right direction is reference manual.

QV links fields with the same names automatically."

Re: Inline dates and imported information

Joseph_Musekura — Sat, 26 Apr 2014 09:13:19 GMT

Hi,

As said above you need to specify a key Field in your script. The keys will be set by puting the same field name on 2 tables. Ex:

Table1:
LOAD fieldA, field1 from table;

inner join (Table1):
LOAD field2 as fieldA, field3 from table;