topic Only to Display Quarter End Values in QlikView https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725628#M538084 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">I have the below data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="229"><TBODY><TR><TD class="xl65" height="17" width="63">YRMON</TD><TD class="xl65" style="border-left: none;" width="69">Amount1</TD><TD class="xl65" style="border-left: none;" width="97">Amount2</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201301</TD><TD class="xl66" style="border-top: none; border-left: none;">100</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201302</TD><TD class="xl66" style="border-top: none; border-left: none;">200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">700</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201303</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">800</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201304</TD><TD class="xl66" style="border-top: none; border-left: none;">400</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201305</TD><TD class="xl66" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1000</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201306</TD><TD class="xl66" style="border-top: none; border-left: none;">600</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1100</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201307</TD><TD class="xl66" style="border-top: none; border-left: none;">700</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1200</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201308</TD><TD class="xl66" style="border-top: none; border-left: none;">800</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201309</TD><TD class="xl66" style="border-top: none; border-left: none;">900</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1300</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201310</TD><TD class="xl66" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201311</TD><TD class="xl66" style="border-top: none; border-left: none;">1100</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1600</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201312</TD><TD class="xl66" style="border-top: none; border-left: none;">1200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1700</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201401</TD><TD class="xl66" style="border-top: none; border-left: none;">1300</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1800</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201402</TD><TD class="xl66" style="border-top: none; border-left: none;">1400</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201403</TD><TD class="xl66" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2000</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201404</TD><TD class="xl66" style="border-top: none; border-left: none;">1600</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201405</TD><TD class="xl66" style="border-top: none; border-left: none;">1700</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2200</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201406</TD><TD class="xl66" style="border-top: none; border-left: none;">1800</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2300</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201407</TD><TD class="xl66" style="border-top: none; border-left: none;">1900</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201408</TD><TD class="xl66" style="border-top: none; border-left: none;">2000</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2500</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201409</TD><TD class="xl66" style="border-top: none; border-left: none;">2100</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2600</TD></TR></TBODY></TABLE><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt; line-height: 1.5em;"><BR /> </SPAN> </P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><STRONG style="font-style: inherit; font-family: inherit; text-decoration: underline;">OUTPUT:</STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD align="right" class="xl65" height="17" width="64">201303</TD><TD align="right" class="xl65" style="border-left: none;" width="64">1100</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201306</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1700</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201309</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2200</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201312</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2900</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201403</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3100</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201406</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4100</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201409</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4700</TD></TR></TBODY></TABLE><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">I want to display in a chart only the Quarter End Year-Mon(Dimension) and the values of the Quarter end as shown above not the sum of the Quarters. Basically the above output in a chart. Please any one can help</P><P class="jive-thread-reply-btn" style="margin: 26px 0 -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><DIV class="jive-thread-reply-btn-correct" style="font-weight: inherit; font-style: inherit; font-family: inherit;"><A _jive_internal="true" href="https://community.qlik.com/message/633875" style="margin: 0 20px 0 0; padding: 2px 14px 4px 28px; font-weight: bold; font-style: inherit; font-family: inherit; color: #3778c7; background-color: #f3f3f3;">Quarter End Value</A><P></P></DIV></BODY></HTML> Tue, 14 Oct 2014 17:01:21 GMT Anonymous 2014-10-14T17:01:21Z Only to Display Quarter End Values https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725628#M538084 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">I have the below data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="229"><TBODY><TR><TD class="xl65" height="17" width="63">YRMON</TD><TD class="xl65" style="border-left: none;" width="69">Amount1</TD><TD class="xl65" style="border-left: none;" width="97">Amount2</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201301</TD><TD class="xl66" style="border-top: none; border-left: none;">100</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201302</TD><TD class="xl66" style="border-top: none; border-left: none;">200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">700</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201303</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">800</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201304</TD><TD class="xl66" style="border-top: none; border-left: none;">400</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201305</TD><TD class="xl66" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1000</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201306</TD><TD class="xl66" style="border-top: none; border-left: none;">600</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1100</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201307</TD><TD class="xl66" style="border-top: none; border-left: none;">700</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1200</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201308</TD><TD class="xl66" style="border-top: none; border-left: none;">800</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201309</TD><TD class="xl66" style="border-top: none; border-left: none;">900</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1300</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201310</TD><TD class="xl66" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201311</TD><TD class="xl66" style="border-top: none; border-left: none;">1100</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1600</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201312</TD><TD class="xl66" style="border-top: none; border-left: none;">1200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1700</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201401</TD><TD class="xl66" style="border-top: none; border-left: none;">1300</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1800</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201402</TD><TD class="xl66" style="border-top: none; border-left: none;">1400</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201403</TD><TD class="xl66" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2000</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201404</TD><TD class="xl66" style="border-top: none; border-left: none;">1600</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201405</TD><TD class="xl66" style="border-top: none; border-left: none;">1700</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2200</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201406</TD><TD class="xl66" style="border-top: none; border-left: none;">1800</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2300</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201407</TD><TD class="xl66" style="border-top: none; border-left: none;">1900</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201408</TD><TD class="xl66" style="border-top: none; border-left: none;">2000</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2500</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201409</TD><TD class="xl66" style="border-top: none; border-left: none;">2100</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2600</TD></TR></TBODY></TABLE><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt; line-height: 1.5em;"><BR /> </SPAN> </P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><STRONG style="font-style: inherit; font-family: inherit; text-decoration: underline;">OUTPUT:</STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD align="right" class="xl65" height="17" width="64">201303</TD><TD align="right" class="xl65" style="border-left: none;" width="64">1100</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201306</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1700</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201309</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2200</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201312</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2900</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201403</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3100</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201406</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4100</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">201409</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4700</TD></TR></TBODY></TABLE><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">I want to display in a chart only the Quarter End Year-Mon(Dimension) and the values of the Quarter end as shown above not the sum of the Quarters. Basically the above output in a chart. Please any one can help</P><P class="jive-thread-reply-btn" style="margin: 26px 0 -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><DIV class="jive-thread-reply-btn-correct" style="font-weight: inherit; font-style: inherit; font-family: inherit;"><A _jive_internal="true" href="https://community.qlik.com/message/633875" style="margin: 0 20px 0 0; padding: 2px 14px 4px 28px; font-weight: bold; font-style: inherit; font-family: inherit; color: #3778c7; background-color: #f3f3f3;">Quarter End Value</A><P></P></DIV></BODY></HTML> Tue, 14 Oct 2014 17:01:21 GMT https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725628#M538084 Anonymous 2014-10-14T17:01:21Z Re: Only to Display Quarter End Values https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725629#M538085 <HTML><HEAD></HEAD><BODY><P>Please do not double post, it makes the community harder for everyone to use. Consolidate your discussion under <A _jive_internal="true" href="https://community.qlik.com/thread/137787">http://community.qlik.com/thread/137787</A> and close this thread.</P><P></P><P>Thanks,</P><P>Vlad</P></BODY></HTML> Tue, 14 Oct 2014 17:07:42 GMT https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725629#M538085 vgutkovsky 2014-10-14T17:07:42Z Re: Only to Display Quarter End Values https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725630#M538086 <HTML><HEAD></HEAD><BODY><P>Didn't got answer in the earlier thread so had to put it in the different discussion forum. But wont do it next time.</P></BODY></HTML> Tue, 14 Oct 2014 17:12:44 GMT https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725630#M538086 Anonymous 2014-10-14T17:12:44Z Re: Only to Display Quarter End Values https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725631#M538087 <HTML><HEAD></HEAD><BODY><P>Replied to your original post.</P></BODY></HTML> Tue, 14 Oct 2014 17:19:09 GMT https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725631#M538087 vgutkovsky 2014-10-14T17:19:09Z Re: Only to Display Quarter End Values https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725632#M538088 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_137789_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/68928_QlikCommunity_Thread_137789_Pic1.JPG.jpg" /></P><P></P><P><IMG alt="QlikCommunity_Thread_137789_Pic2.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/68929_QlikCommunity_Thread_137789_Pic2.JPG.jpg" style="width: 620px; height: 289px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 14 Oct 2014 22:49:05 GMT https://community.qlik.com/t5/QlikView/Only-to-Display-Quarter-End-Values/m-p/725632#M538088 MarcoWedel 2014-10-14T22:49:05Z