Calculate difference between different values

[#1]

Hello!

Description of my problem:

I work with giving credit to clients in the transportation industry, we work with credit lines to our customers where we accept a certain total lending to a customer. Our credit lines also have an expiration date.

I have the following information loaded into QlikView:

1.Total lending in the current situation
2.Total granted lending
3.Utgångsdatum for credit
4.Customer

What I want is one or two diagrams showing how much space a particular customer has left on his loan (2-1). I wish also to see how much time is left until the credit runs out of time (3).

Can you help me with this?

Sincerely

Jim

[#2]

Sorry, wrong...

3. Expiredate for the credit.