topic Re: Subtracting based on two dimension vlaues in QlikView https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557228#M208023 <HTML><HEAD></HEAD><BODY><P>Find the attachment@</P></BODY></HTML> Mon, 06 Jan 2014 21:45:19 GMT Anonymous 2014-01-06T21:45:19Z Subtracting based on two dimension vlaues https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557226#M208021 <HTML><HEAD></HEAD><BODY><P>Dears,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Assume I have two stages of a process and each one has start and end date. How could I subtract the end date of the first from the start date of the second so that i could know if there any gap between them.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Process</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>stage</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Start Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>End Date</STRONG></TH></TR><TR><TD style="padding: 2px;">Process 1</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1/1/2014</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">1/2/2104</SPAN></TD></TR><TR><TD style="padding: 2px;">Process 1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">1/3/2014</SPAN></TD><TD style="padding: 2px;">1/5/2014</TD></TR></TBODY></TABLE><P>Regards, </P></BODY></HTML> Mon, 06 Jan 2014 21:01:05 GMT https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557226#M208021 2014-01-06T21:01:05Z Re: Subtracting based on two dimension vlaues https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557227#M208022 <HTML><HEAD></HEAD><BODY><P>Hope this enclosed file will help you...</P></BODY></HTML> Mon, 06 Jan 2014 21:33:51 GMT https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557227#M208022 MK_QSL 2014-01-06T21:33:51Z Re: Subtracting based on two dimension vlaues https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557228#M208023 <HTML><HEAD></HEAD><BODY><P>Find the attachment@</P></BODY></HTML> Mon, 06 Jan 2014 21:45:19 GMT https://community.qlik.com/t5/QlikView/Subtracting-based-on-two-dimension-vlaues/m-p/557228#M208023 Anonymous 2014-01-06T21:45:19Z