Hello all,
I refer you to this conversation http://community.qlik.com/message/164426#164426
I have found no solution so far. A prerequisite to a solution existing in Qlikview is the following :
Does Qlikview have an equivalent to the Excel formula arrays ?
I want to return for each Work order (referenced by WONUM) how many WONUM were reported before (where the reported date is REPORTDATE)
Not that here an aggregation is not possible since the date is a dimension and dynamic, so I have had no luck with set analysis.
| WONUM | REPORTDATE | WONUM created before |
| BC142529 | 2011/08/03 | 0 |
| BC142796 | 2011/08/07 | 1 |
| BC142808 | 2011/08/08 | 2 |
| BC143523 | 2011/08/20 | 3 |
| BC143531 | 2011/08/21 | 4 |
| BC143679 | 2011/08/24 | 5 |
Where for instance C2 = {=SUM(IF((B2>B$1:B$7),1,0))} Formula array
I can't seem to find how to do this in Qlikview.
Please help on this thread or the other one.
Thanks
Arthur
