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/1198456#M883833 <HTML><HEAD></HEAD><BODY><P>Try this.</P></BODY></HTML> Tue, 04 Oct 2016 08:31:53 GMT varshavig12 2016-10-04T08:31:53Z 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