topic Re: Dates in QlikView

Dates

dseelam — Mon, 19 May 2014 17:54:54 GMT

Hello Every one,

Have an issue displaying only following dates, If you see below data it is easy to display following 1day in same row by using an expression Count(DISTINCT if([WE]-[CS]=-1,SID)) in the straight table what if I want to show the data CWS in the below row following 1day after CWE in the above row (basically comparing dates in different rows and columns)

Bucket	ID	WS	WE	CWS	CWE
30Days	514787	5/29/2008	5/28/2009	5/29/2009	5/28/2014
30Days	249441	3/10/2009	6/09/2009	6/10/2009	6/9/2014
30Days	999193	6/13/2009	6/12/2010	6/13/2010	6/12/2014
30Days	954600	6/02/2009	6/01/2010	6/2/2010	6/1/2014
30Days	497011	6/19/2009	6/18/2010	6/19/2010	6/18/2014
30Days	562339	5/30/2009	5/31/2010	6/1/2010	5/31/2014
30Days	184984	6/02/2009	6/01/2010	6/2/2010	6/1/2014
30Days	359602	5/29/2009	5/28/2010	5/29/2010	5/28/2014
30Days	983575	5/28/2009	5/27/2010	5/28/2010	5/27/2014
30Days	620565	5/28/2009	5/27/2010	5/28/2010	5/27/2014
30Days	072146	5/27/2009	5/26/2010	5/27/2010	5/26/2014
30Days	337763	6/15/2009	6/14/2010	6/15/2010	6/14/2014
30Days	905495	5/29/2009	5/28/2010	5/29/2010	5/28/2014
30Days	359831	6/02/2009	6/01/2010	6/2/2010	6/1/2014
30Days	179721	6/09/2009	6/08/2010	6/9/2010	6/8/2014
30Days	236470	6/11/2009	6/10/2010	6/11/2010	6/10/2014
30Days	394478	9/28/2010	9/27/2011	9/28/2011	5/27/2014
30Days	399500	12/05/2012	12/04/2013	12/5/2013	6/4/2014
30Days	714062	6/19/2012	6/18/2013	6/19/2013	6/18/2014

Thanks in advance

Re: Dates

Mon, 19 May 2014 17:58:49 GMT

I'm not sure I quite understand what you're asking, could you please rephrase it?

Re: Dates

its_anandrjs — Mon, 19 May 2014 18:01:24 GMT

Can you elaborate more with sample out put what you required.

Re: Dates

dseelam — Mon, 19 May 2014 18:18:16 GMT

I need all the ID's where CWS following next day of WE in one table which I achieved using expression Count(DISTINCT if([WE]-[CS]=-1,ID))

In other table I need all the ID's where CWS following next day of CWE in the above row

For example in the below table give me the ID's if CWS in the 2nd row(with ID 249441) follows CWE in the 1st row (with ID 514787) same if CWS in the 3rd row(ID 999193) follows CWE in the 2nd row (ID 249441) ?

Bucket	ID	WS	WE	CWS	CWE
30Days	514787	5/29/2008	5/28/2009	5/29/2009	5/28/2014
30Days	249441	3/10/2009	6/09/2009	6/10/2009	6/9/2014
30Days	999193	6/13/2009	6/12/2010	6/13/2010	6/12/2014

Sorry for not elaborating Hope this helps

Thanks

Re: Dates

dseelam — Mon, 19 May 2014 18:18:35 GMT

I need all the ID's where CWS following next day of WE in one table which I achieved using expressionCount(DISTINCT if([WE]-[CS]=-1,ID))

In other table I need all the ID's where CWS following next day of CWE in the above row

Bucket	ID	WS	WE	CWS	CWE
30Days	514787	5/29/2008	5/28/2009	5/29/2009	5/28/2014
30Days	249441	3/10/2009	6/09/2009	6/10/2009	6/9/2014
30Days	999193	6/13/2009	6/12/2010	6/13/2010	6/12/2014

Sorry for not elaborating Hope this helps

Thanks