topic Qliksense bar chart for contract effective &amp; Expiring date in App Development https://community.qlik.com/t5/App-Development/Qliksense-bar-chart-for-contract-effective-amp-Expiring-date/m-p/1824311#M67670 <P>Hi All,</P><P>I have a below set of data.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Contract Name</STRONG></P></TD><TD><P><STRONG>Contract Type</STRONG></P></TD><TD><P><STRONG>Effective Date</STRONG></P></TD><TD><P><STRONG>Expiration Date</STRONG></P></TD></TR><TR><TD><P>Contract1</P></TD><TD><P>Amendment</P></TD><TD><P>2017-12-10</P></TD><TD><P>2021-12-10</P></TD></TR><TR><TD><P>Contract2</P></TD><TD><P>Other</P></TD><TD><P>2016-12-20</P></TD><TD><P>2021-12-19</P></TD></TR><TR><TD><P>Contract3</P></TD><TD><P>Amendment</P></TD><TD><P>2016-07-28</P></TD><TD><P>2021-07-27</P></TD></TR><TR><TD><P>Contract4</P></TD><TD><P>Order</P></TD><TD><P>2016-11-09</P></TD><TD><P>2021-10-30</P></TD></TR><TR><TD><P>Contract5</P></TD><TD><P>Maintenance</P></TD><TD><P>2016-09-20</P></TD><TD><P>2021-09-15</P></TD></TR><TR><TD><P>Contract6</P></TD><TD><P>Other</P></TD><TD><P>2016-08-31</P></TD><TD><P>2021-07-30</P></TD></TR><TR><TD><P>Contract7</P></TD><TD><P>Amendment</P></TD><TD><P>2020-07-31</P></TD><TD><P>2021-07-30</P></TD></TR><TR><TD><P>Contract8</P></TD><TD><P>Order</P></TD><TD><P>2018-11-30</P></TD><TD><P>2021-11-29</P></TD></TR><TR><TD><P>Contract9</P></TD><TD><P>Maintenance</P></TD><TD><P>2018-11-30</P></TD><TD><P>2021-11-29</P></TD></TR><TR><TD><P>Contract10</P></TD><TD><P>Other</P></TD><TD><P>2019-12-15</P></TD><TD><P>2021-12-14</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is it possible to create a view as below.</P><P>&nbsp;</P><P>Should have contract name &amp; type dimensions. Then Effective and Expiration date should shown in Bar with today as reference line and # no of days remaining to expire</P><P>reference screenshot.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Deepak87_0-1627142935082.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59094i6B61A416E6300F9F/image-size/medium?v=v2&amp;px=400" role="button" title="Deepak87_0-1627142935082.png" alt="Deepak87_0-1627142935082.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 24 Jul 2021 16:10:11 GMT Deepak87 2021-07-24T16:10:11Z Qliksense bar chart for contract effective & Expiring date https://community.qlik.com/t5/App-Development/Qliksense-bar-chart-for-contract-effective-amp-Expiring-date/m-p/1824311#M67670 <P>Hi All,</P><P>I have a below set of data.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Contract Name</STRONG></P></TD><TD><P><STRONG>Contract Type</STRONG></P></TD><TD><P><STRONG>Effective Date</STRONG></P></TD><TD><P><STRONG>Expiration Date</STRONG></P></TD></TR><TR><TD><P>Contract1</P></TD><TD><P>Amendment</P></TD><TD><P>2017-12-10</P></TD><TD><P>2021-12-10</P></TD></TR><TR><TD><P>Contract2</P></TD><TD><P>Other</P></TD><TD><P>2016-12-20</P></TD><TD><P>2021-12-19</P></TD></TR><TR><TD><P>Contract3</P></TD><TD><P>Amendment</P></TD><TD><P>2016-07-28</P></TD><TD><P>2021-07-27</P></TD></TR><TR><TD><P>Contract4</P></TD><TD><P>Order</P></TD><TD><P>2016-11-09</P></TD><TD><P>2021-10-30</P></TD></TR><TR><TD><P>Contract5</P></TD><TD><P>Maintenance</P></TD><TD><P>2016-09-20</P></TD><TD><P>2021-09-15</P></TD></TR><TR><TD><P>Contract6</P></TD><TD><P>Other</P></TD><TD><P>2016-08-31</P></TD><TD><P>2021-07-30</P></TD></TR><TR><TD><P>Contract7</P></TD><TD><P>Amendment</P></TD><TD><P>2020-07-31</P></TD><TD><P>2021-07-30</P></TD></TR><TR><TD><P>Contract8</P></TD><TD><P>Order</P></TD><TD><P>2018-11-30</P></TD><TD><P>2021-11-29</P></TD></TR><TR><TD><P>Contract9</P></TD><TD><P>Maintenance</P></TD><TD><P>2018-11-30</P></TD><TD><P>2021-11-29</P></TD></TR><TR><TD><P>Contract10</P></TD><TD><P>Other</P></TD><TD><P>2019-12-15</P></TD><TD><P>2021-12-14</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is it possible to create a view as below.</P><P>&nbsp;</P><P>Should have contract name &amp; type dimensions. Then Effective and Expiration date should shown in Bar with today as reference line and # no of days remaining to expire</P><P>reference screenshot.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Deepak87_0-1627142935082.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59094i6B61A416E6300F9F/image-size/medium?v=v2&amp;px=400" role="button" title="Deepak87_0-1627142935082.png" alt="Deepak87_0-1627142935082.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 24 Jul 2021 16:10:11 GMT https://community.qlik.com/t5/App-Development/Qliksense-bar-chart-for-contract-effective-amp-Expiring-date/m-p/1824311#M67670 Deepak87 2021-07-24T16:10:11Z