topic How to link years in different fields? in QlikView

How to link years in different fields?

Fri, 28 Sep 2012 19:59:39 GMT

Hi,

I have a table where I store the yeara client join a group (YearIn) and the date the client left the group (YearOut).

How can I create a chart where I have years in dimension and in expression I want the number of client who joined each year and the number of client who left each year?

I hope it is clear.

Any ideas?

Thanks

Re: How to link years in different fields?

MayilVahanan — Fri, 28 Sep 2012 21:08:29 GMT

Can you post a sample file in it? Its easy to refer it. Or can you post a table viewer?

Re: How to link years in different fields?

Sat, 29 Sep 2012 08:53:46 GMT

Hi,

Here are some sample talbe :

Client table :

Client Name YearIn YearOut

Smith 2010 2012

Jack 2009 2011

Martin 2009 2012

Evans 2008

Newton 2010 2011

Calendar table:

Year

2008

2009

2010

2011

The chart I want will look like this:

Nb client In Nb client Out

Year

2008 1 0

2009 2 0

2010 2 0

2011 0 2

2012 0 2

Re: How to link years in different fields?

Eugeny_Ilyin — Sat, 29 Sep 2012 10:10:25 GMT

You may create table from "Client table"

-----

ClientName, Year, Type

Smith, 2010, In

Smith, 2012, Out

......

And use expressions with 'Set Analysis'

Re: How to link years in different fields?

Sat, 29 Sep 2012 11:27:42 GMT

I wanted to know if it was possible to do that without creating a new table.