topic Re: Create a link Table in QlikView

Create a link Table

Anonymous — Mon, 02 Sep 2013 09:03:37 GMT

Can anyone show me how I can show which roster cycle a person is in based on the the the division they work in. Each staff member works within a division. Each division has it's own cycle. Each Cycle has it's own publish date (based on the date of hours owed), I keep getting duplications :

Hours owed:

Date,

Hours owed,

Staff Number

Staff:

Title,

First Name,

Last Name,

Staff Number,

Division:

Division Name,

Staff Number

Cycle Name:

Cycle Name

Division Name

n.b. each division will either be cycle 1 or cycle 2

Cycle Dates:

Hours Owed Date

Cycle Name

Publish Date

n.b. There is a duplication in this table as there are 2 hours owed dates, one of them has a publish date for cycle 1 and a the other has a publish date for cycle 2.

I need a way to show the publish date (without duplications) for the staff members hours owed from a specific hours owed date. Any Help Appreciated.

Thanks

Phil

Re: Create a link Table

kaushiknsolanki — Mon, 02 Sep 2013 09:08:41 GMT

Hi,

I see a straight linking between them, why would you require the link table?

Why dont you load them as it is? what is the problem after doing this, if you have already done this?

Regards,

Kaushik Solanki

Re: Create a link Table

Anonymous — Mon, 02 Sep 2013 09:29:40 GMT

I end up with 2 rows for each staff member. Please see example

Hours Owed Date	Division	Person_StaffNumber	Person_FirstName	Person_Surname	PBalance_CodeName	Roster Cycle	Publish Date	Published	Roster Cycle1	Hours Owed Value
										-
19/08/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	01/07/2013	Published	Eccles	5.5
19/08/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	5.5
26/08/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	01/07/2013	Published	Eccles	-8
26/08/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	-8
02/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	01/07/2013	Published	Eccles	-9.5
02/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	-9.5
09/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	01/07/2013	Published	Eccles	-11
09/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	-11
16/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	-12.5
16/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	26/08/2013	Published	Eccles	-12.5
23/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	-14
23/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	26/08/2013	Published	Eccles	-14
30/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	22/07/2013	Published	Stott	-15.5
30/09/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	26/08/2013	Published	Eccles	-15.5
07/10/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	26/08/2013	Published	Eccles	-53
07/10/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	16/09/2013	Not Yet Published	Stott	-53
14/10/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	26/08/2013	Published	Eccles	-54.5
14/10/2013	B8	11111111	First Name	Last Name	Hrs +/- Target	Stott	16/09/2013	Not Yet Published	Stott	-54.5

Re: Create a link Table

kaushiknsolanki — Mon, 02 Sep 2013 09:32:31 GMT

Hi,

Can you upload the example qvw file, it would help to understand your problem in detail.

Regards,

Kaushik Solanki

Re: Create a link Table

Mon, 02 Sep 2013 09:42:33 GMT

Hi,

Its should be data related problem/column name not properly mapped.

Please share with some data and table viewer screen shot.

Karthik

Re: Create a link Table

Anonymous — Thu, 05 Sep 2013 10:49:27 GMT

I can't as there is too much data that needs anonomising.

I know the problem is a simple one to resolve. I am just too much of a novice. I need a way that the script filters any cycle publish date information if the person does not belong to that roster cycle.

The problem I have is that the person appears on 2 rows (once from cycle A & once for cycle B).

I know I am making an easy query very complicated.

Phil