topic Accumulation - RangeSum Comparative in QlikView https://community.qlik.com/t5/QlikView/Accumulation-RangeSum-Comparative/m-p/670339#M243593 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I've attached a test model with what it is I am trying to achieve. There are different comparative views that the EU can utilize to see different reporting periods. My challenge is this</P><P></P><OL><LI>I have a calculated dimension that originally i suppressed nulls to ensure that rangesum in the expression did not still autopopulate all the other dates<OL><LI>If I suppress nulls, then the underlying values get removed from the rangesum. This is NOT what I want to happen</LI></OL></LI><LI>If I use a straight MonthName type field then all dates get populated. If a user is on 12 month rolling, then they should only ever see 12 MonthNames in the pivot table. If the user is on MTD, then only 1 month</LI><LI>The expression I have is a pick match that handles how to aggregate based on this switch of periods</LI></OL><P></P><P>I cannot get this to pivot correctly with the right periods and the right values with suppress nulls enabled. How do i get this right all</P><P></P><P></P><P>Thanks,</P><P>Byron</P></BODY></HTML> Wed, 13 Aug 2014 08:01:23 GMT 2014-08-13T08:01:23Z Accumulation - RangeSum Comparative https://community.qlik.com/t5/QlikView/Accumulation-RangeSum-Comparative/m-p/670339#M243593 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I've attached a test model with what it is I am trying to achieve. There are different comparative views that the EU can utilize to see different reporting periods. My challenge is this</P><P></P><OL><LI>I have a calculated dimension that originally i suppressed nulls to ensure that rangesum in the expression did not still autopopulate all the other dates<OL><LI>If I suppress nulls, then the underlying values get removed from the rangesum. This is NOT what I want to happen</LI></OL></LI><LI>If I use a straight MonthName type field then all dates get populated. If a user is on 12 month rolling, then they should only ever see 12 MonthNames in the pivot table. If the user is on MTD, then only 1 month</LI><LI>The expression I have is a pick match that handles how to aggregate based on this switch of periods</LI></OL><P></P><P>I cannot get this to pivot correctly with the right periods and the right values with suppress nulls enabled. How do i get this right all</P><P></P><P></P><P>Thanks,</P><P>Byron</P></BODY></HTML> Wed, 13 Aug 2014 08:01:23 GMT https://community.qlik.com/t5/QlikView/Accumulation-RangeSum-Comparative/m-p/670339#M243593 2014-08-13T08:01:23Z Re: Accumulation - RangeSum Comparative https://community.qlik.com/t5/QlikView/Accumulation-RangeSum-Comparative/m-p/670340#M243594 <HTML><HEAD></HEAD><BODY><P>I've added a false value to the calculated dimension that reads 'TOTAL'. This way I represent the null as a subtotal value when populating the calendar periods. This makes things look cleaner but would still like to know if there is a way around this</P><P></P><P></P><P>Cheers,</P><P>Byron</P></BODY></HTML> Wed, 13 Aug 2014 09:17:38 GMT https://community.qlik.com/t5/QlikView/Accumulation-RangeSum-Comparative/m-p/670340#M243594 2014-08-13T09:17:38Z