topic Re: How to include all the values for rolling total inspite of Dimension limits in QlikView https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72572#M12028 <HTML><HEAD></HEAD><BODY><P>Yeah. I didn't change the dimension. Thanks Again. Sorry for the confusion <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 06 Apr 2018 19:03:07 GMT varunreddy 2018-04-06T19:03:07Z How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72564#M12020 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to perform the rangesum function. I have values from 1 to 10 and I am trying to perform rolling sum. I am getting the data as desired. But when I try to choose top 5, my rolling sum is changing.</P><P></P><P>I am trying to see if we can do top 5 with all the values included in the rolling sum.</P><P></P><P>For example:</P><P></P><P>In below screen shot, In left report my range sum is working fine.</P><P></P><P>In right report, I am trying to display top 5. Here numbers are changing. Is there a way I show top 5 and numbers doesn't change?</P><P></P><P><IMG __jive_id="198791" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198791_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Thanks in advance!</P><P></P><P>Cheers,</P><P>Varun</P></BODY></HTML> Fri, 06 Apr 2018 18:27:45 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72564#M12020 varunreddy 2018-04-06T18:27:45Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72565#M12021 <HTML><HEAD></HEAD><BODY><P>Would you be able to attach the test file?</P></BODY></HTML> Fri, 06 Apr 2018 18:29:12 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72565#M12021 sunny_talwar 2018-04-06T18:29:12Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72566#M12022 <HTML><HEAD></HEAD><BODY><P>Attached</P></BODY></HTML> Fri, 06 Apr 2018 18:31:24 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72566#M12022 varunreddy 2018-04-06T18:31:24Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72567#M12023 <HTML><HEAD></HEAD><BODY><P>The attached app doesn't have the charts <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 06 Apr 2018 18:33:21 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72567#M12023 sunny_talwar 2018-04-06T18:33:21Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72568#M12024 <HTML><HEAD></HEAD><BODY><P>Sorry. Added</P></BODY></HTML> Fri, 06 Apr 2018 18:37:04 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72568#M12024 varunreddy 2018-04-06T18:37:04Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72569#M12025 <HTML><HEAD></HEAD><BODY><P>Use if statement with rank rather than using dimension limits</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198795_Capture.PNG" style="height: 267px; width: 620px;" /></P></BODY></HTML> Fri, 06 Apr 2018 18:39:12 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72569#M12025 sunny_talwar 2018-04-06T18:39:12Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72570#M12026 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Thanks for the quick turn around. This seems to be working fine.</P><P></P><P>This is not working as expected as I have different scenario. My bad, I mocked up wrong scenario.</P><P></P><P>I actually have one dimension Week and one metric Data.</P><P></P><P>I am trying to get top 5 weeks using rangesum for the data. I am attaching new data set with the QVW.</P><P></P><P>Please take a look.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198793_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 06 Apr 2018 18:53:15 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72570#M12026 varunreddy 2018-04-06T18:53:15Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72571#M12027 <HTML><HEAD></HEAD><BODY><P>What is the problem my friend?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198797_Capture.PNG" style="height: auto;" /></P><P></P><P>You might have forgot to change the dimension from Test to Week...</P></BODY></HTML> Fri, 06 Apr 2018 18:58:34 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72571#M12027 sunny_talwar 2018-04-06T18:58:34Z Re: How to include all the values for rolling total inspite of Dimension limits https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72572#M12028 <HTML><HEAD></HEAD><BODY><P>Yeah. I didn't change the dimension. Thanks Again. Sorry for the confusion <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 06 Apr 2018 19:03:07 GMT https://community.qlik.com/t5/QlikView/How-to-include-all-the-values-for-rolling-total-inspite-of/m-p/72572#M12028 varunreddy 2018-04-06T19:03:07Z