Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to link years in different fields?

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

Tags (1)
4 Replies

Re: How to link years in different fields?

Hi

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

Not applicable

Re: How to link years in different fields?

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

eugenyilyin
Contributor II

Re: How to link years in different fields?

Hi

You may create table from "Client table"

-----

ClientName, Year, Type

Smith, 2010, In

Smith, 2012, Out

......

And use expressions with 'Set Analysis'

Not applicable

Re: How to link years in different fields?

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

Community Browser