Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dseelam
Contributor

Dates

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)

BucketIDWSWECWSCWE
30Days5147875/29/20085/28/20095/29/20095/28/2014
30Days2494413/10/20096/09/20096/10/20096/9/2014
30Days9991936/13/20096/12/20106/13/20106/12/2014
30Days9546006/02/20096/01/20106/2/20106/1/2014
30Days4970116/19/20096/18/20106/19/20106/18/2014
30Days5623395/30/20095/31/20106/1/20105/31/2014
30Days1849846/02/20096/01/20106/2/20106/1/2014
30Days3596025/29/20095/28/20105/29/20105/28/2014
30Days9835755/28/20095/27/20105/28/20105/27/2014
30Days6205655/28/20095/27/20105/28/20105/27/2014
30Days0721465/27/20095/26/20105/27/20105/26/2014
30Days3377636/15/20096/14/20106/15/20106/14/2014
30Days9054955/29/20095/28/20105/29/20105/28/2014
30Days3598316/02/20096/01/20106/2/20106/1/2014
30Days1797216/09/20096/08/20106/9/20106/8/2014
30Days2364706/11/20096/10/20106/11/20106/10/2014
30Days3944789/28/20109/27/20119/28/20115/27/2014
30Days39950012/05/201212/04/201312/5/20136/4/2014
30Days7140626/19/20126/18/20136/19/20136/18/2014

Thanks in advance

4 Replies
Not applicable

Re: Dates

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

Re: Dates

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

dseelam
Contributor

Re: Dates

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) ?


BucketIDWSWECWSCWE
30Days5147875/29/20085/28/20095/29/20095/28/2014
30Days2494413/10/20096/09/20096/10/20096/9/2014
30Days9991936/13/20096/12/20106/13/20106/12/2014

Sorry for not elaborating Hope this helps

Thanks

dseelam
Contributor

Re: Dates

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

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) ?


BucketIDWSWECWSCWE
30Days5147875/29/20085/28/20095/29/20095/28/2014
30Days2494413/10/20096/09/20096/10/20096/9/2014
30Days9991936/13/20096/12/20106/13/20106/12/2014

Sorry for not elaborating Hope this helps

Thanks

Community Browser