topic output the last date in QlikView https://community.qlik.com/t5/QlikView/output-the-last-date/m-p/205294#M1284774 <HTML><HEAD></HEAD><BODY><P></P><P>I have created the following Table.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 529px; border-collapse: collapse; height: 152px;" width="529"><COLGROUP><COL style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55" /><COL style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61" /><COL span="6" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" width="37" /><COL style="width: 15pt; mso-width-source: userset; mso-width-alt: 731;" width="20" /><COL style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;" width="19" /></COLGROUP><TBODY><TR height="15" style="height: 11.25pt;"><TD class="xl65" height="15" style="background-color: transparent; width: 41pt; height: 11.25pt; border: #f0f0f0;" width="55">ArtNr</TD><TD class="xl66" style="background-color: transparent; width: 46pt; border: #f0f0f0;" width="61">ab</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK1</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK2</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK3</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK4</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK5</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">EK</TD><TD class="xl65" style="background-color: transparent; width: 15pt; border: #f0f0f0;" width="20">PG</TD><TD class="xl65" style="background-color: transparent; width: 14pt; border: #f0f0f0;" width="19">KR</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"><P>07.06.2005</P></TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,89</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,09</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,69</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,4</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">85</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">03.01.2007</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,09</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,39</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,55</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,69</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">78</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">19.01.2007</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,09</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,39</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,55</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,69</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">78</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000003</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">10.05.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,15</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">2,99</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,75</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,32</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">76</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000003</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">27.05.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,15</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">2,99</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,75</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,32</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">76</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">26.04.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">42,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">44,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">48,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">52,95</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">45</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">27.05.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">42,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">44,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">48,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">52,95</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">45</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">08.06.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5,49</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,99</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5,75</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">6,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22.06.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">45</TD></TR></TBODY></TABLE><P>The end result should look like this:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 284pt; border-collapse: collapse;" width="377"><COLGROUP><COL style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55" /><COL style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61" /><COL span="6" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" width="37" /><COL style="width: 15pt; mso-width-source: userset; mso-width-alt: 731;" width="20" /><COL style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;" width="19" /></COLGROUP><TBODY><TR height="15" style="height: 11.25pt;"><TD class="xl65" height="15" style="background-color: transparent; width: 41pt; height: 11.25pt; border: #f0f0f0;" width="55">ArtNr</TD><TD class="xl66" style="background-color: transparent; width: 46pt; border: #f0f0f0;" width="61">ab</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK1</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK2</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK3</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK4</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK5</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">EK</TD><TD class="xl65" style="background-color: transparent; width: 15pt; border: #f0f0f0;" width="20">PG</TD><TD class="xl65" style="background-color: transparent; width: 14pt; border: #f0f0f0;" width="19">KR</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="background-color: transparent; border: #f0f0f0;">19.01.2007</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,09</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,25</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,39</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,55</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,69</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">1,45</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">78</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000003</TD><TD align="right" class="xl68" style="background-color: transparent; border: #f0f0f0;">27.05.2005</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,15</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">2,99</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,45</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,75</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">1,32</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">76</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="background-color: transparent; border: #f0f0f0;">22.06.2005</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">22,83</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">45</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Thanks a lot!</P><P>C.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT crainerc 2026-01-26T18:19:17Z output the last date https://community.qlik.com/t5/QlikView/output-the-last-date/m-p/205294#M1284774 <HTML><HEAD></HEAD><BODY><P></P><P>I have created the following Table.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 529px; border-collapse: collapse; height: 152px;" width="529"><COLGROUP><COL style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55" /><COL style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61" /><COL span="6" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" width="37" /><COL style="width: 15pt; mso-width-source: userset; mso-width-alt: 731;" width="20" /><COL style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;" width="19" /></COLGROUP><TBODY><TR height="15" style="height: 11.25pt;"><TD class="xl65" height="15" style="background-color: transparent; width: 41pt; height: 11.25pt; border: #f0f0f0;" width="55">ArtNr</TD><TD class="xl66" style="background-color: transparent; width: 46pt; border: #f0f0f0;" width="61">ab</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK1</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK2</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK3</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK4</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK5</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">EK</TD><TD class="xl65" style="background-color: transparent; width: 15pt; border: #f0f0f0;" width="20">PG</TD><TD class="xl65" style="background-color: transparent; width: 14pt; border: #f0f0f0;" width="19">KR</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"><P>07.06.2005</P></TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,89</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,09</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,69</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,4</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">85</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">03.01.2007</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,09</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,39</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,55</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,69</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">78</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">19.01.2007</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,09</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,39</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,55</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,69</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">78</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000003</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">10.05.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,15</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">2,99</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,75</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,32</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">76</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000003</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">27.05.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,15</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">2,99</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,45</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3,75</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1,32</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">76</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">26.04.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">42,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">44,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">48,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">52,95</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">45</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">27.05.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">42,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">44,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">48,5</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">52,95</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">45</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">08.06.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5,49</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4,99</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5,75</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">6,25</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22.06.2005</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">40,29</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">22,83</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD align="right" class="xl67" style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">45</TD></TR></TBODY></TABLE><P>The end result should look like this:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 284pt; border-collapse: collapse;" width="377"><COLGROUP><COL style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55" /><COL style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61" /><COL span="6" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" width="37" /><COL style="width: 15pt; mso-width-source: userset; mso-width-alt: 731;" width="20" /><COL style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;" width="19" /></COLGROUP><TBODY><TR height="15" style="height: 11.25pt;"><TD class="xl65" height="15" style="background-color: transparent; width: 41pt; height: 11.25pt; border: #f0f0f0;" width="55">ArtNr</TD><TD class="xl66" style="background-color: transparent; width: 46pt; border: #f0f0f0;" width="61">ab</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK1</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK2</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK3</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK4</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">VK5</TD><TD class="xl65" style="background-color: transparent; width: 28pt; border: #f0f0f0;" width="37">EK</TD><TD class="xl65" style="background-color: transparent; width: 15pt; border: #f0f0f0;" width="20">PG</TD><TD class="xl65" style="background-color: transparent; width: 14pt; border: #f0f0f0;" width="19">KR</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000001</TD><TD align="right" class="xl68" style="background-color: transparent; border: #f0f0f0;">19.01.2007</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,09</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,25</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,39</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,55</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,69</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">1,45</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">78</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000003</TD><TD align="right" class="xl68" style="background-color: transparent; border: #f0f0f0;">27.05.2005</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,15</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">2,99</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,45</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3,75</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">1,32</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">76</TD></TR><TR height="15" style="height: 11.25pt;"><TD align="right" class="xl67" height="15" style="background-color: transparent; height: 11.25pt; border: #f0f0f0;">22000013</TD><TD align="right" class="xl68" style="background-color: transparent; border: #f0f0f0;">22.06.2005</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">40,29</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">22,83</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">3</TD><TD align="right" class="xl67" style="background-color: transparent; border: #f0f0f0;">45</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Thanks a lot!</P><P>C.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/output-the-last-date/m-p/205294#M1284774 crainerc 2026-01-26T18:19:17Z output the last date https://community.qlik.com/t5/QlikView/output-the-last-date/m-p/205295#M1284777 <HTML><HEAD></HEAD><BODY><P>If your "last date" doesn't need to respond to selections, the easiest might be to establish a new field during the load:</P><P style="padding-left:30px;">if(ArtNr&lt;&gt;previous(ArtNr),ab) as Lastab<BR />...<BR />ORDER BY ArtNr, ab DESC</P><P>And then use Lastab instead of ab as the dimension.</P></BODY></HTML> Wed, 23 Jun 2010 21:20:31 GMT https://community.qlik.com/t5/QlikView/output-the-last-date/m-p/205295#M1284777 johnw 2010-06-23T21:20:31Z