topic Re: Date find and filter in QlikView

Date find and filter

Wed, 17 Jun 2015 12:28:35 GMT

ID	Category	Title	Date
1	A	ASI	10-04-2015
1	A	ASI	29-08-2014
1	A	DVA	13-10-2014
1	B	AKE	05-12-2014
1	B	AKE	05-12-2014
1	B	ES	05-12-2014
1	B	EEN	09-12-2014
2	A	UPE	22-04-2015
2	B	EMO	15-06-2015
2	B	EMO	15-06-2015
2	B	EMO	15-06-2015
2	B	EMO	15-06-2015
2	B	EMO	15-06-2015
2	B	REA	15-06-2015
2	A	ASI	18-09-2014
2	A	NTE	26-01-2015
3	A	UPE	30-04-2015
3	B	ORL	24-09-2014
3	A	ASI	12-12-2014
3	A	NTE	16-01-2015
4	A	NTE	15-06-2015
4	B	ACA	07-03-2012
4	A	ASI	28-07-2014

I bet this is a simple one, but I have been off QlikView for a while and can't make my mind up, so here we are:

I need to identify in the above table, the IDs who first had a category A item and then a Category B. Then identify from those with A and B Category, which title were first followed in both categories, of course at later stage I will need to return many other filed that are satisfactory to both statement: A & B category = True and A category before B.

Thanks for your help,

Re: Date find and filter

Gysbert_Wassenaar — Wed, 17 Jun 2015 13:16:18 GMT

ID 1 has A before B. And it has three Titles on the same first date after A. So, which one of those three is the first title?

Re: Date find and filter

Wed, 17 Jun 2015 13:22:10 GMT

Well it is the case since the date is the order date, so to identify the first one i believe I would have to use FirstSortedValue

But I am still puzzled for the rest...

Re: Date find and filter

Gysbert_Wassenaar — Wed, 17 Jun 2015 13:48:57 GMT

See attached example

Re: Date find and filter

Wed, 17 Jun 2015 15:47:00 GMT

Thanks Gysbert, it works. I have to amend it to fit my other requirements but overall manage to have it enable on my Dashboard. Well Done!