topic Re: Chart Formatting in QlikView https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363028#M821355 <HTML><HEAD></HEAD><BODY><P>Yes and I can still use the Month slicer? If so, can you attached the sample app?</P></BODY></HTML> Mon, 07 Aug 2017 17:11:58 GMT Anonymous 2017-08-07T17:11:58Z Chart Formatting https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363026#M821353 <HTML><HEAD></HEAD><BODY><P>I have the below chart. There will be a trigger on the page that shows the max 2 months. What I would like to do is show the lattest two months but also show for my % dimension the last three months. So for example. the line graph would show the % for month 201706,201707 &amp; 201708. (Visually I think that looks better)</P><P></P><P>The requestor would like to be able to filter on month when needed.</P><P></P><P></P><P></P><P><IMG __jive_id="172661" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172661_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P></P><P></P><P>Like below but only showing two months and not three.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363026#M821353 Anonymous 2020-11-25T16:16:04Z Re: Chart Formatting https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363027#M821354 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172676_Capture.PNG" style="height: 285px; width: 620px;" /></P></BODY></HTML> Mon, 07 Aug 2017 14:57:09 GMT https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363027#M821354 Anil_Babu_Samineni 2017-08-07T14:57:09Z Re: Chart Formatting https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363028#M821355 <HTML><HEAD></HEAD><BODY><P>Yes and I can still use the Month slicer? If so, can you attached the sample app?</P></BODY></HTML> Mon, 07 Aug 2017 17:11:58 GMT https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363028#M821355 Anonymous 2017-08-07T17:11:58Z Re: Chart Formatting https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363029#M821356 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Num(Count({&lt;STATUS = {"1"} &gt;} ID)/</STRONG></P><P><STRONG>Above(Count({&lt;STATUS= {"1"}, <SPAN style="color: #ff0000;">MONTH</SPAN>&gt;} ID), 1) - 1, '#.00%')</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172688_Capture.PNG" style="height: 338px; width: 620px;" /></P></BODY></HTML> Mon, 07 Aug 2017 17:18:10 GMT https://community.qlik.com/t5/QlikView/Chart-Formatting/m-p/1363029#M821356 sunny_talwar 2017-08-07T17:18:10Z