topic How to get Approval Transaccions without Last State in QlikView

How to get Approval Transaccions without Last State

pgalvezt — Tue, 18 Oct 2011 20:22:44 GMT

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!!

How to get Approval Transaccions without Last State

Wed, 19 Oct 2011 01:03:52 GMT

Can you post a sample application?

Regards,

Kiran.

Re: How to get Approval Transaccions without Last State

pgalvezt — Wed, 19 Oct 2011 22:11:33 GMT

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

Re: How to get Approval Transaccions without Last State

pgalvezt — Thu, 20 Oct 2011 20:07:46 GMT

Any Help?

How to get Approval Transaccions without Last State

Tue, 25 Oct 2011 17:51:40 GMT

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.