topic Re: Top two values in current month comparing the same values with previous month in QlikView https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198475#M883852 <HTML><HEAD></HEAD><BODY><P>Hi Varsha this solution is working fine but in the current month, ie the selected month has only one value,the problem is here in the current month it is shownig one value and this value is not showing, in the previous month and previous month is showing the top 5 values in their months can you please help me out</P></BODY></HTML> Tue, 18 Oct 2016 07:35:45 GMT 2016-10-18T07:35:45Z Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198449#M883826 <HTML><HEAD></HEAD><BODY><P>Hi all Please help me out top two values in current month comparing the same with previous month.</P><P></P><P>In June the top two profitted cuntries are Argentina and Japan</P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1134906-139359/pastedImage_0.png" target="_blank"><IMG class="jive-image image-1" height="209" src="https://community.qlik.com/legacyfs/online/139421_pastedImage_0.png" width="515" /></A></P><P>In May the top two profitted cuntries are America and Argentina </P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1134906-139360/pastedImage_1.png" target="_blank"><IMG class="jive-image image-2" height="194" src="https://community.qlik.com/legacyfs/online/139422_pastedImage_1.png" width="495" /></A></P><P>What i want is when i click on jun i want both june and may data to dispaly and the comparision should be between the selected month (jun) and top two values of it&nbsp; Argentina and Japan to Argentina and Japanin May</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1134906-139367/pastedImage_2.png" target="_blank"><IMG class="jive-image image-3" height="328" src="https://community.qlik.com/legacyfs/online/139423_pastedImage_2.png" width="743" /></A></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198449#M883826 2020-11-25T16:16:04Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198450#M883827 <HTML><HEAD></HEAD><BODY><P>You want to see this on a bar graph with MONTHYEAR and COUNTRY as dimension?</P></BODY></HTML> Mon, 03 Oct 2016 19:39:57 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198450#M883827 sunny_talwar 2016-10-03T19:39:57Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198451#M883828 <HTML><HEAD></HEAD><BODY><P>Yes i want to see the current month top values in comparison to previous months. Or any other way to represent</P></BODY></HTML> Tue, 04 Oct 2016 02:52:49 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198451#M883828 2016-10-04T02:52:49Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198452#M883829 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139509_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 04 Oct 2016 06:58:56 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198452#M883829 varshavig12 2016-10-04T06:58:56Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198453#M883830 <HTML><HEAD></HEAD><BODY><P>My Requirement is actually this if a user selects the current month the higest 2 values in current month </P><P>and i want to see how these higest values are in previous 3 months user can select any month<BR />if he selects any month the previous 3 months data should appear</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139520_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 04 Oct 2016 07:43:31 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198453#M883830 2016-10-04T07:43:31Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198454#M883831 <HTML><HEAD></HEAD><BODY><P>&nbsp; Using global grouping,</P><P>I got this:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139526_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>But this is one is showing largest two from the current and the previous two months.</P><P>I will try as per your requirement and let you know</P></BODY></HTML> Tue, 04 Oct 2016 08:21:53 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198454#M883831 varshavig12 2016-10-04T08:21:53Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198455#M883832 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139527_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>this is ok ?</P></BODY></HTML> Tue, 04 Oct 2016 08:28:13 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198455#M883832 varshavig12 2016-10-04T08:28:13Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198456#M883833 <HTML><HEAD></HEAD><BODY><P>Try this.</P></BODY></HTML> Tue, 04 Oct 2016 08:31:53 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198456#M883833 varshavig12 2016-10-04T08:31:53Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198457#M883834 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/message/1136042">Re: Need help</A></P></BODY></HTML> Tue, 04 Oct 2016 11:55:06 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198457#M883834 varshavig12 2016-10-04T11:55:06Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198458#M883835 <HTML><HEAD></HEAD><BODY><P>Hi its looking great but it was not working in my qvw im bit worried</P></BODY></HTML> Wed, 05 Oct 2016 05:22:45 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198458#M883835 2016-10-05T05:22:45Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198459#M883836 <HTML><HEAD></HEAD><BODY><P>Where are you getting stuck ?</P><P>What's your output ?</P><P>Can you share your qvw or some sample data in excel, so that I can create a small app as per your data?</P></BODY></HTML> Wed, 05 Oct 2016 05:36:56 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198459#M883836 varshavig12 2016-10-05T05:36:56Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198460#M883837 <HTML><HEAD></HEAD><BODY><P>Try this in Second chart Expression</P><P>sum({&lt;Year={$(=max(Year)-1)},Country=P({&lt;Year={$(=max(Year))}&gt;}Country)&gt;}Sales)</P></BODY></HTML> Wed, 05 Oct 2016 06:49:23 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198460#M883837 2016-10-05T06:49:23Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198461#M883838 <HTML><HEAD></HEAD><BODY><P>My month format is 2016 may&nbsp; in the dashboard i want to write an expression on this format</P></BODY></HTML> Wed, 05 Oct 2016 09:24:04 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198461#M883838 2016-10-05T09:24:04Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198462#M883839 <HTML><HEAD></HEAD><BODY><P>you can write expression for 201605 and then convert it into 2016 may.</P></BODY></HTML> Wed, 05 Oct 2016 10:37:17 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198462#M883839 varshavig12 2016-10-05T10:37:17Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198463#M883840 <HTML><HEAD></HEAD><BODY><P>may be like this:</P><P></P><P>--&gt; for previous month:</P><P></P><P>sum({$&lt;MonthYear={"$(=date(AddMonths(max(MonthYear),-1),'YYYY MMM'))"}&gt;}Value )</P></BODY></HTML> Wed, 05 Oct 2016 10:55:53 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198463#M883840 varshavig12 2016-10-05T10:55:53Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198464#M883841 <HTML><HEAD></HEAD><BODY><P>Hi varsha thank you so much its working fine great job and can i get a stacked chart in this </P></BODY></HTML> Wed, 05 Oct 2016 17:56:32 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198464#M883841 2016-10-05T17:56:32Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198465#M883842 <HTML><HEAD></HEAD><BODY><P>Hi i will try this </P></BODY></HTML> Wed, 05 Oct 2016 17:57:10 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198465#M883842 2016-10-05T17:57:10Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198466#M883843 <HTML><HEAD></HEAD><BODY><P>You're welcome!! I don't think so, give it a try.</P></BODY></HTML> Thu, 06 Oct 2016 03:15:13 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198466#M883843 varshavig12 2016-10-06T03:15:13Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198467#M883844 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="139801" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139801_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Like this ?</P><P></P><P></P><P></P><P>or</P><P>two different charts:</P><P></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/139802_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 06 Oct 2016 03:23:43 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198467#M883844 varshavig12 2016-10-06T03:23:43Z Re: Top two values in current month comparing the same values with previous month https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198468#M883845 <HTML><HEAD></HEAD><BODY><P>Check this:</P><P></P><P>Stacked bar chart:</P></BODY></HTML> Thu, 06 Oct 2016 05:12:09 GMT https://community.qlik.com/t5/QlikView/Top-two-values-in-current-month-comparing-the-same-values-with/m-p/1198468#M883845 varshavig12 2016-10-06T05:12:09Z