Re: Inline dates and imported information - Qlik Community

Anonymous · ‎2014-04-23

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?

whiteline · ‎2014-04-23

Hi.

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

Anonymous · ‎2014-04-23

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?

whiteline · ‎2014-04-23

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.

its_anandrjs · ‎2014-04-23

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.

Anonymous · ‎2014-04-25

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

whiteline · ‎2014-04-26

Hi.

Actually, nothing has changed:

"The right direction is reference manual.

QV links fields with the same names automatically."

Joseph_Musekura · ‎2014-04-26

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;