I use QLIK SENSE. Gentlemen, I would like some help… I have a table where a PLATE is used on the same day for 2 different NF invoices.
PLACA | DT_ISSUE | DT_RECEIPT | U$ | NF |
NED4394 | 05/23/2014 | 05/27/2014 | U$ 983.28 | 12269073 |
NED4394 | 05/23/2014 | 05/27/2014 | U$ 782.72 | 12269081 |
In the example above the PLATE NED4394 issued on 05/23/2014 in two different NF. I would like to mark the NF that do this and also be able to count.
TYPE RESULT 1
DT_ISSUE | NF (Distinct) |
05/23/2014 | 2 |
TYPE RESULT 2
NF | DT_ISSUE (Not distinct) |
12269073 | 2 |
12269081 | 2 |
There is also a rule that within 05 days between DT_ ISSUE and DT_ RECEIPT no distinct PLATE can issue ANY other NF. So I wish I could also mark the NFs that fits this rule and also be able to count.
PLACA | DT_ISSUE | DT_RECEIPT | U$ | NF |
NED4394 | 06/05/2014 | 14/05/2014 | U$ 1,570.53 | 12166950 |
NED4394 | 08/05/2014 | 22/05/2014 | U$ 1,100.24 | 12221547 |
Thank you very much in advance
