How to compare data within the same column (QLIK SENSE)
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.
