topic Calculate difference between different values in QlikView https://community.qlik.com/t5/QlikView/Calculate-difference-between-different-values/m-p/551057#M1135947 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello!</SPAN><BR /><BR /><SPAN class="hps">Description</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">my problem</SPAN><SPAN>:</SPAN><BR /><BR /><SPAN class="hps">I work</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="alt-edited hps">giving</SPAN> <SPAN class="hps">credit to clients</SPAN> <SPAN class="hps">in the transportation</SPAN> <SPAN class="hps">industry</SPAN><SPAN>,</SPAN> <SPAN class="hps">we work with</SPAN> <SPAN class="hps">credit lines</SPAN> <SPAN class="hps">to our customers</SPAN> <SPAN class="hps">where</SPAN> <SPAN class="hps">we accept</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">certain total</SPAN> <SPAN class="hps">lending</SPAN> <SPAN class="hps">to a customer.</SPAN> <SPAN class="hps">Our</SPAN> <SPAN class="alt-edited hps">credit lines</SPAN> <SPAN class="hps">also have</SPAN> <SPAN class="hps">an expiration date.</SPAN><BR /><BR /><SPAN class="hps">I have the following</SPAN> <SPAN class="hps">information</SPAN> <SPAN class="hps">loaded into</SPAN> <SPAN class="hps">QlikView</SPAN><SPAN>:</SPAN><BR /><BR /><SPAN class="hps">1.Total</SPAN> <SPAN class="hps">lending</SPAN> <SPAN class="hps">in the current situation</SPAN><BR /><SPAN class="hps">2.Total</SPAN> <SPAN class="hps">granted</SPAN> <SPAN class="hps">lending</SPAN><BR /><SPAN class="hps">3.Utgångsdatum</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">credit</SPAN><BR /><SPAN class="hps">4.Customer</SPAN><BR /><BR /><SPAN class="hps">What I</SPAN> <SPAN class="hps">want is</SPAN> <SPAN class="hps">one or</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">diagrams showing how</SPAN> <SPAN class="hps">much space</SPAN> <SPAN class="hps">a particular customer</SPAN> <SPAN class="hps">has</SPAN> <SPAN class="hps">left on</SPAN> <SPAN class="hps">his loan</SPAN> <SPAN class="atn hps">(</SPAN><SPAN>2-1).</SPAN> <SPAN class="hps">I wish</SPAN> <SPAN class="hps">also</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">see how</SPAN> <SPAN class="hps">much time is</SPAN> <SPAN class="hps">left</SPAN> <SPAN class="hps">until the credit</SPAN> <SPAN class="hps">runs out</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">time</SPAN> <SPAN class="hps">(3).</SPAN><BR /><BR /><SPAN class="hps">Can you help</SPAN> <SPAN class="hps">me with this?</SPAN><BR /><BR /><SPAN class="hps">Sincerely</SPAN><BR /><BR /><SPAN class="hps">Jim</SPAN></SPAN></P></BODY></HTML> Mon, 14 Oct 2013 07:46:02 GMT 2013-10-14T07:46:02Z Calculate difference between different values https://community.qlik.com/t5/QlikView/Calculate-difference-between-different-values/m-p/551057#M1135947 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello!</SPAN><BR /><BR /><SPAN class="hps">Description</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">my problem</SPAN><SPAN>:</SPAN><BR /><BR /><SPAN class="hps">I work</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="alt-edited hps">giving</SPAN> <SPAN class="hps">credit to clients</SPAN> <SPAN class="hps">in the transportation</SPAN> <SPAN class="hps">industry</SPAN><SPAN>,</SPAN> <SPAN class="hps">we work with</SPAN> <SPAN class="hps">credit lines</SPAN> <SPAN class="hps">to our customers</SPAN> <SPAN class="hps">where</SPAN> <SPAN class="hps">we accept</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">certain total</SPAN> <SPAN class="hps">lending</SPAN> <SPAN class="hps">to a customer.</SPAN> <SPAN class="hps">Our</SPAN> <SPAN class="alt-edited hps">credit lines</SPAN> <SPAN class="hps">also have</SPAN> <SPAN class="hps">an expiration date.</SPAN><BR /><BR /><SPAN class="hps">I have the following</SPAN> <SPAN class="hps">information</SPAN> <SPAN class="hps">loaded into</SPAN> <SPAN class="hps">QlikView</SPAN><SPAN>:</SPAN><BR /><BR /><SPAN class="hps">1.Total</SPAN> <SPAN class="hps">lending</SPAN> <SPAN class="hps">in the current situation</SPAN><BR /><SPAN class="hps">2.Total</SPAN> <SPAN class="hps">granted</SPAN> <SPAN class="hps">lending</SPAN><BR /><SPAN class="hps">3.Utgångsdatum</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">credit</SPAN><BR /><SPAN class="hps">4.Customer</SPAN><BR /><BR /><SPAN class="hps">What I</SPAN> <SPAN class="hps">want is</SPAN> <SPAN class="hps">one or</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">diagrams showing how</SPAN> <SPAN class="hps">much space</SPAN> <SPAN class="hps">a particular customer</SPAN> <SPAN class="hps">has</SPAN> <SPAN class="hps">left on</SPAN> <SPAN class="hps">his loan</SPAN> <SPAN class="atn hps">(</SPAN><SPAN>2-1).</SPAN> <SPAN class="hps">I wish</SPAN> <SPAN class="hps">also</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">see how</SPAN> <SPAN class="hps">much time is</SPAN> <SPAN class="hps">left</SPAN> <SPAN class="hps">until the credit</SPAN> <SPAN class="hps">runs out</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">time</SPAN> <SPAN class="hps">(3).</SPAN><BR /><BR /><SPAN class="hps">Can you help</SPAN> <SPAN class="hps">me with this?</SPAN><BR /><BR /><SPAN class="hps">Sincerely</SPAN><BR /><BR /><SPAN class="hps">Jim</SPAN></SPAN></P></BODY></HTML> Mon, 14 Oct 2013 07:46:02 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-different-values/m-p/551057#M1135947 2013-10-14T07:46:02Z Re: Calculate difference between different values https://community.qlik.com/t5/QlikView/Calculate-difference-between-different-values/m-p/551058#M1135948 <HTML><HEAD></HEAD><BODY><P>Sorry, wrong...</P><P>3. Expiredate for the credit.</P></BODY></HTML> Mon, 14 Oct 2013 08:02:38 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-different-values/m-p/551058#M1135948 2013-10-14T08:02:38Z