Discussion Board for collaboration related to QlikView App Development.
I have high transaction data (15-20 million rows) which contains status per transaction. Transactions can fail, but may eventually "Pass".
The final status is important. Failed transactions need to get tagged with Pass so they don't need triaging.
# of fails can be arbitrary so nested Previous function only goes that far. I am not sure about looping. May take too long to process large volume.
I am looking for an output with the last 2 derived fields with Final Status and Resolved Dates based on the pass status for each Script# + Medication combo.
I am trying to get to this output. Transactions attempted = 15, Scripts impacted = 2, Meds impacted = 3, Scripts resolved = 1
Any help is appreciated. Thanks!
Hi @shaheermecci ,
You need to create one view where you need to identify the max date for all the Script+Medication pair and left join it to the main table based on your Script+Medication key.
I managed to get the desired output in the attached QVW.
Pl see and let me know if that works, in my opinion it is the only possible way to that.
*Pl mark correct if works.*
View solution in original post