topic Re: dates calcultion in QlikView https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047171#M351930 <HTML><HEAD></HEAD><BODY><P>Hi Siva,</P><P></P><P>Check:</P><P><A href="https://community.qlik.com/docs/DOC-5314">Find Net Working Days</A></P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Fri, 08 Jan 2016 05:47:16 GMT amit_saini 2016-01-08T05:47:16Z dates calcultion https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047168#M351927 <HTML><HEAD></HEAD><BODY><P>hi experts,</P><P>i have two tables like below i want last 3 days(without holidays) and 5 days(without holidays) as a separate buckets.when ever i click 3 days bucket or 5 days bucket it has to display last 3 days sales or 5 days sales in bar chart.</P><P>in billing day 1-working day 0-holiday,</P><P>can you please help me... </P><P></P><P></P><P></P><P></P><P></P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="183"><TBODY><TR><TD class="xl63" height="20" width="67">Date</TD><TD class="xl63" style="border-left: none;" width="53">Sales</TD><TD class="xl63" style="border-left: none;" width="63">Country</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4566.24</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4122.30</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">3-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4185.72</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">4-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5073.60</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">5-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">951.30</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">6-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4566.24</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">7-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4724.79</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">8-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3963.75</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">9-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4230.11</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">10-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4299.88</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">11-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5073.60</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">12-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">317.10</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">13-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3963.75</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">14-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3963.75</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">15-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4724.79</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">16-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3963.75</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">17-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4230.11</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">18-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1458.66</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">19-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1204.98</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">20-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4724.79</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">21-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3963.75</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">22-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4230.11</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">23-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4724.79</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">24-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3963.75</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">25-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1426.95</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">26-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">780.07</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">27-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4724.79</TD><TD class="xl66" style="border-top: none; border-left: none;">Germany</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5288.40</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4774.25</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">3-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4847.70</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">4-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5876.00</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">5-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1101.75</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">6-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5288.40</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">7-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5472.03</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">8-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4590.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">9-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4899.12</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">10-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4979.91</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">11-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5876.00</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">12-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">367.25</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">13-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4590.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">14-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4590.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">15-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5472.03</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">16-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4590.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">17-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4899.12</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">18-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1689.35</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">19-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1395.55</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">20-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5472.03</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">21-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4590.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">22-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4899.12</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">23-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5472.03</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">24-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4590.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">25-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1652.63</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">26-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">903.44</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">27-Apr-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5472.03</TD><TD class="xl66" style="border-top: none; border-left: none;">UK</TD></TR></TBODY></TABLE><P>2nd table</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="202"><TBODY><TR><TD height="20" width="67">Date</TD><TD width="72">Billing Day</TD><TD width="63">Country</TD></TR><TR><TD align="right" class="xl65" height="20">1-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">2-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">3-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">4-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">5-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">6-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">7-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">8-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">9-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">10-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">11-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">12-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">13-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">14-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">15-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">16-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">17-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">18-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">19-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">20-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">21-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">22-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">23-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">24-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">25-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">26-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">27-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">28-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">29-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">30-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>Germany</TD></TR><TR><TD align="right" class="xl65" height="20">1-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">2-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">3-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">4-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">5-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">6-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">7-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">8-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">9-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">10-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">11-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">12-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">13-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">14-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">15-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">16-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">17-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">18-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">19-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">20-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">21-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">22-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">23-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">24-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">25-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">26-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #9c0006; font-family: Calibri; background: #ffc7ce;">0</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">27-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">28-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">29-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR><TR><TD align="right" class="xl65" height="20">30-Apr-15</TD><TD align="right" style="font-size: 11pt; color: #006100; font-family: Calibri; background: #c6efce;">1</TD><TD>UK</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 07 Jan 2016 16:26:17 GMT https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047168#M351927 2016-01-07T16:26:17Z Re: dates calcultion https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047169#M351928 <HTML><HEAD></HEAD><BODY><P>please post your expected result.</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 08 Jan 2016 00:50:49 GMT https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047169#M351928 MarcoWedel 2016-01-08T00:50:49Z Re: dates calcultion https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047170#M351929 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P><P></P><P>Did the script step by step for understanding purpose.</P></BODY></HTML> Fri, 08 Jan 2016 05:39:49 GMT https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047170#M351929 MayilVahanan 2016-01-08T05:39:49Z Re: dates calcultion https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047171#M351930 <HTML><HEAD></HEAD><BODY><P>Hi Siva,</P><P></P><P>Check:</P><P><A href="https://community.qlik.com/docs/DOC-5314">Find Net Working Days</A></P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Fri, 08 Jan 2016 05:47:16 GMT https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047171#M351930 amit_saini 2016-01-08T05:47:16Z Re: dates calcultion https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047172#M351931 <HTML><HEAD></HEAD><BODY><P>in list box</P><P>bucket3</P><P>bucket5</P><P></P><P>when ever click in the bucket need to&nbsp; show last 3days sales in bar charts</P></BODY></HTML> Fri, 08 Jan 2016 08:30:34 GMT https://community.qlik.com/t5/QlikView/dates-calcultion/m-p/1047172#M351931 2016-01-08T08:30:34Z