topic Expression in QlikView

topic Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/1459822#M796426 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Consider we have these there tables:</P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#FFFFFF","textAlign":"left","padding":"NaN","backgroundColor":"#4F81BD","fontFamily":"Calibri","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 383px;"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">date</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="87">Mainaccount</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="87">Dimension</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="134">balance</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">33</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">28</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">32</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">40</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">30</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">20</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">31</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">36</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">30</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">29</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">25</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">24</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">40</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">42</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">44</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">65</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">24</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">50</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/10/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">29</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/11/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">30</TD></TR></TBODY></TABLE><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="139"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">date</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="64">sale</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1000</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1300</TD></TR></TBODY></TABLE><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="139"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">date</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="64">month</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/10/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/11/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR></TBODY></TABLE><P>I would like to trace the Dimension Balance by sales per month<,the result should be like these:</P><P></P><P>         </P><TABLE border="0" cellpadding="0" cellspacing="0" width="917"><TBODY><TR><TD class="xl65" height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">month</TD><TD class="xl66" width="102">Mainaccount</TD><TD class="xl66" width="89">Dimension</TD><TD class="xl65" width="140">Dimension balance</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="172">Total balance per month</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="149">Total sale per month</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="87">Toal %</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="103">Dimension %</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">10</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">1</TD><TD class="xl68" style="border-top: none;">163</TD><TD class="xl68">280</TD><TD class="xl68">1000</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">28%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">16%</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">10</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">2</TD><TD class="xl68" style="border-top: none;">117</TD><TD class="xl68" style="border-top: none;">280</TD><TD class="xl68" style="border-top: none;">1000</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">28%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">12%</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">11</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">2</TD><TD class="xl68" style="border-top: none;">227</TD><TD class="xl68" style="border-top: none;">402</TD><TD class="xl68" style="border-top: none;">1300</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">31%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">17%</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">11</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">1</TD><TD class="xl68" style="border-top: none;">175</TD><TD class="xl68" style="border-top: none;">402</TD><TD class="xl68" style="border-top: none;">1300</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">31%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">13%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1459822#M796426 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Consider we have these there tables:</P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#FFFFFF","textAlign":"left","padding":"NaN","backgroundColor":"#4F81BD","fontFamily":"Calibri","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 383px;"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">date</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="87">Mainaccount</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="87">Dimension</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="134">balance</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">33</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">28</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">32</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">40</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">30</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">20</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">31</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">36</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">30</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">29</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">25</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">24</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">40</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">42</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">44</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">65</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">24</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">50</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/10/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">29</TD></TR><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/11/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">100</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none;">2</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">30</TD></TR></TBODY></TABLE><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="139"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">date</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="64">sale</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">1000</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">1300</TD></TR></TBODY></TABLE><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="139"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">date</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="64">month</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">10/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/1/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/2/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/3/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/4/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/5/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/6/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/7/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/8/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/9/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">11/10/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/11/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: #dce6f1;">10/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #dce6f1;">10</TD></TR><TR><TD align="right" class="xl65" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7;">11/30/2017</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none;">11</TD></TR></TBODY></TABLE><P>I would like to trace the Dimension Balance by sales per month<,the result should be like these:</P><P></P><P>         </P><TABLE border="0" cellpadding="0" cellspacing="0" width="917"><TBODY><TR><TD class="xl65" height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border: 0.5pt solid #95b3d7; background: #4f81bd;" width="75">month</TD><TD class="xl66" width="102">Mainaccount</TD><TD class="xl66" width="89">Dimension</TD><TD class="xl65" width="140">Dimension balance</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="172">Total balance per month</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="149">Total sale per month</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="87">Toal %</TD><TD class="xl67" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: #4f81bd;" width="103">Dimension %</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">10</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">1</TD><TD class="xl68" style="border-top: none;">163</TD><TD class="xl68">280</TD><TD class="xl68">1000</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">28%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">16%</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">10</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">2</TD><TD class="xl68" style="border-top: none;">117</TD><TD class="xl68" style="border-top: none;">280</TD><TD class="xl68" style="border-top: none;">1000</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">28%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">12%</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">11</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">2</TD><TD class="xl68" style="border-top: none;">227</TD><TD class="xl68" style="border-top: none;">402</TD><TD class="xl68" style="border-top: none;">1300</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">31%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">17%</TD></TR><TR><TD class="xl68" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: 0.5pt solid #95b3d7; background: white;">11</TD><TD class="xl68" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none;">1</TD><TD class="xl68" style="border-top: none;">175</TD><TD class="xl68" style="border-top: none;">402</TD><TD class="xl68" style="border-top: none;">1300</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: none; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">31%</TD><TD class="xl69" style="font-size: 11pt; color: black; font-family: Calibri; border-top: 0.5pt solid #95b3d7; border-right: 0.5pt solid #95b3d7; border-bottom: 0.5pt solid #95b3d7; border-left: none; background: white;">13%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1459822#M796426 Anonymous 2020-11-25T16:16:04Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1459823#M796427 <HTML><HEAD></HEAD><BODY><P>I have found the answer</P><P>=sum (total <month>aggr( sum(balance),month))</P><P>and </P><P>=sum (total <month>aggr( sum(sale),month))</P></BODY></HTML> Fri, 05 Jan 2018 17:21:49 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1459823#M796427 Anonymous 2018-01-05T17:21:49Z