9 Replies Latest reply: Oct 24, 2011 6:46 PM by Nina_Kachirja RSS

How to get the last Status "Approval" that no contains Status "Complete"

Pablo Gálvez

Hello!!

 

I have the table transactions where I have "Status" Like New, Approval And Complete. When I do click over Approval Transaction, QlikView counts all the status Approval, but this include the status Complete when the document ending for that state. What I want is to do Click over Approval but QlikView doesn´t have to count the document that has "Complete" State. I mean, The last state has to be Approval only and no to count the Approval that contains State Complete . I hope that you have undertood the question.

 

Thanks!!