Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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?
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...
See attached example
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!