How to get Approval Transaccions without Last State

[pgalvezt]

Hello!!

I would like to get the pending documents in a certain date... I have the table transactions where I have "Status" Like New, Approval And Complete. When I do click over Approval, 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 in state Complete, only Approval. I hope that you have undertood the question.

Thanks!!

[#2]

Can you post a sample application?

Regards,

Kiran.

[pgalvezt]

all the documents historial has how last state (Complete or Rejected). At the moment when I want to count the Approval State like the last State. And no counts the Approval that they have complete as last State.

Thanks

[pgalvezt]

Any Help?

[#5]

Hi,

I dont have qlikview right now but you can try the following logic. To find the no.of documents in approval stage:

count(Distinct {<Status={'Approved'}>} Documents)-count(Distinct{<Status={'Approved','Closed'}>} Documents):

Documents which are approved - Documents which are approved&closed.

Hope this helps,

Kiran.