topic Re: Trailing Sales for 12 months in QlikView https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979458#M1220941 <P>I'd create a Date in the script</P> <P><STRONG>MakeDate(Year,Month,1) as Date</STRONG></P> <P>Then use this expression</P> <P><STRONG> Sum({&lt;Date={"$(='&gt;=' &amp; Date(MonthStart(Max(Date), -12)) &amp; '&lt;' &amp; Date(MonthStart(Max(Date))))"}&gt;} Sales)</STRONG></P> <P>&nbsp;</P> Sat, 10 Sep 2022 11:07:24 GMT BrunPierre 2022-09-10T11:07:24Z Trailing Sales for 12 months https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979453#M1220939 <P>Please find the attached data and i have to write a set expression in qliksense for the trailing 12months,</P> <P>here i don't have date in my data but only the months and year.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>kindly provide the solution to the above query urgently</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 10 Sep 2022 09:35:58 GMT https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979453#M1220939 Charu_1628 2022-09-10T09:35:58Z Re: Trailing Sales for 12 months https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979454#M1220940 <TABLE width="402"> <TBODY> <TR> <TD width="64">Year</TD> <TD width="64">Month</TD> <TD width="146">Unit Name</TD> <TD width="128">Sales</TD> </TR> <TR> <TD>2021</TD> <TD>4</TD> <TD width="146">B208+Chetak</TD> <TD>1891.18</TD> </TR> <TR> <TD>2021</TD> <TD>4</TD> <TD width="146">GFPL-Mfg.</TD> <TD>499.54</TD> </TR> <TR> <TD>2021</TD> <TD>4</TD> <TD width="146">GFPL-Trading</TD> <TD>180.39</TD> </TR> <TR> <TD>2021</TD> <TD>4</TD> <TD width="146">FP</TD> <TD>1038.98</TD> </TR> <TR> <TD>2021</TD> <TD>4</TD> <TD width="146">SKG</TD> <TD>1003.36</TD> </TR> <TR> <TD>2021</TD> <TD>4</TD> <TD width="146">Vizag</TD> <TD>824.04</TD> </TR> <TR> <TD>2021</TD> <TD>5</TD> <TD width="146">B208+Chetak</TD> <TD>1785.90</TD> </TR> <TR> <TD>2021</TD> <TD>5</TD> <TD width="146">GFPL-Mfg.</TD> <TD>663.84</TD> </TR> <TR> <TD>2021</TD> <TD>5</TD> <TD width="146">GFPL-Trading</TD> <TD>337.13</TD> </TR> <TR> <TD>2021</TD> <TD>5</TD> <TD width="146">FP</TD> <TD>1180.61</TD> </TR> <TR> <TD>2021</TD> <TD>5</TD> <TD width="146">SKG</TD> <TD>1116.52</TD> </TR> <TR> <TD>2021</TD> <TD>5</TD> <TD width="146">Vizag</TD> <TD>773.98</TD> </TR> <TR> <TD>2021</TD> <TD>6</TD> <TD width="146">B208+Chetak</TD> <TD>2183.78</TD> </TR> <TR> <TD>2021</TD> <TD>6</TD> <TD width="146">GFPL-Mfg.</TD> <TD>610.22</TD> </TR> <TR> <TD>2021</TD> <TD>6</TD> <TD width="146">GFPL-Trading</TD> <TD>273.13</TD> </TR> <TR> <TD>2021</TD> <TD>6</TD> <TD width="146">FP</TD> <TD>1158.39</TD> </TR> <TR> <TD>2021</TD> <TD>6</TD> <TD width="146">SKG</TD> <TD>1247.05</TD> </TR> <TR> <TD>2021</TD> <TD>6</TD> <TD width="146">Vizag</TD> <TD>985.59</TD> </TR> <TR> <TD>2021</TD> <TD>7</TD> <TD width="146">B208+Chetak</TD> <TD>1204.50</TD> </TR> <TR> <TD>2021</TD> <TD>7</TD> <TD width="146">GFPL-Mfg.</TD> <TD>569.11</TD> </TR> <TR> <TD>2021</TD> <TD>7</TD> <TD width="146">GFPL-Trading</TD> <TD>215.73</TD> </TR> <TR> <TD>2021</TD> <TD>7</TD> <TD width="146">FP</TD> <TD>767.75</TD> </TR> <TR> <TD>2021</TD> <TD>7</TD> <TD width="146">SKG</TD> <TD>1163.59</TD> </TR> <TR> <TD>2021</TD> <TD>7</TD> <TD width="146">Vizag</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 903.51</TD> </TR> <TR> <TD>2021</TD> <TD>8</TD> <TD width="146">B208+Chetak</TD> <TD>2963.05</TD> </TR> <TR> <TD>2021</TD> <TD>8</TD> <TD width="146">GFPL-Mfg.</TD> <TD>653.74</TD> </TR> <TR> <TD>2021</TD> <TD>8</TD> <TD width="146">GFPL-Trading</TD> <TD>341.04</TD> </TR> <TR> <TD>2021</TD> <TD>8</TD> <TD width="146">FP</TD> <TD>1181.80</TD> </TR> <TR> <TD>2021</TD> <TD>8</TD> <TD width="146">SKG</TD> <TD>1388.25</TD> </TR> <TR> <TD>2021</TD> <TD>8</TD> <TD width="146">Vizag</TD> <TD>1018.61</TD> </TR> <TR> <TD>2021</TD> <TD>9</TD> <TD width="146">B208+Chetak</TD> <TD>2962.10</TD> </TR> <TR> <TD>2021</TD> <TD>9</TD> <TD width="146">GFPL-Mfg.</TD> <TD>728.61</TD> </TR> <TR> <TD>2021</TD> <TD>9</TD> <TD width="146">GFPL-Trading</TD> <TD>251.38</TD> </TR> <TR> <TD>2021</TD> <TD>9</TD> <TD width="146">FP</TD> <TD>1312.39</TD> </TR> <TR> <TD>2021</TD> <TD>9</TD> <TD width="146">SKG</TD> <TD>1405.85</TD> </TR> <TR> <TD>2021</TD> <TD>9</TD> <TD width="146">Vizag</TD> <TD>1685.73</TD> </TR> <TR> <TD>2021</TD> <TD>10</TD> <TD width="146">B208+Chetak</TD> <TD>2812.39</TD> </TR> <TR> <TD>2021</TD> <TD>10</TD> <TD width="146">GFPL-Mfg.</TD> <TD>766.98</TD> </TR> <TR> <TD>2021</TD> <TD>10</TD> <TD width="146">GFPL-Trading</TD> <TD>309.14</TD> </TR> <TR> <TD>2021</TD> <TD>10</TD> <TD width="146">FP</TD> <TD>1285.43</TD> </TR> <TR> <TD>2021</TD> <TD>10</TD> <TD width="146">SKG</TD> <TD>1388.37</TD> </TR> <TR> <TD>2021</TD> <TD>10</TD> <TD width="146">Vizag</TD> <TD>1241.34</TD> </TR> <TR> <TD>2021</TD> <TD>11</TD> <TD width="146">B208+Chetak</TD> <TD>2561.90</TD> </TR> <TR> <TD>2021</TD> <TD>11</TD> <TD width="146">GFPL-Mfg.</TD> <TD>489.24</TD> </TR> <TR> <TD>2021</TD> <TD>11</TD> <TD width="146">GFPL-Trading</TD> <TD>179.73</TD> </TR> <TR> <TD>2021</TD> <TD>11</TD> <TD width="146">FP</TD> <TD>1112.71</TD> </TR> <TR> <TD>2021</TD> <TD>11</TD> <TD width="146">SKG</TD> <TD>1228.46</TD> </TR> <TR> <TD>2021</TD> <TD>11</TD> <TD width="146">Vizag</TD> <TD>882.90</TD> </TR> <TR> <TD>2021</TD> <TD>12</TD> <TD width="146">B208+Chetak</TD> <TD>2857.22</TD> </TR> <TR> <TD>2021</TD> <TD>12</TD> <TD width="146">GFPL-Mfg.</TD> <TD>806.84</TD> </TR> <TR> <TD>2021</TD> <TD>12</TD> <TD width="146">GFPL-Trading</TD> <TD>370.59</TD> </TR> <TR> <TD>2021</TD> <TD>12</TD> <TD width="146">FP</TD> <TD>1464.61</TD> </TR> <TR> <TD>2021</TD> <TD>12</TD> <TD width="146">SKG</TD> <TD>1282.06</TD> </TR> <TR> <TD>2021</TD> <TD>12</TD> <TD width="146">Vizag</TD> <TD>1532.19</TD> </TR> <TR> <TD>2022</TD> <TD>1</TD> <TD width="146">B208+Chetak</TD> <TD>2368.48</TD> </TR> <TR> <TD>2022</TD> <TD>1</TD> <TD width="146">GFPL-Mfg.</TD> <TD>676.61</TD> </TR> <TR> <TD>2022</TD> <TD>1</TD> <TD width="146">GFPL-Trading</TD> <TD>335.02</TD> </TR> <TR> <TD>2022</TD> <TD>1</TD> <TD width="146">FP</TD> <TD>1195.51</TD> </TR> <TR> <TD>2022</TD> <TD>1</TD> <TD width="146">SKG</TD> <TD>1069.42</TD> </TR> <TR> <TD>2022</TD> <TD>1</TD> <TD width="146">Vizag</TD> <TD>1187.84</TD> </TR> <TR> <TD>2022</TD> <TD>2</TD> <TD width="146">B208+Chetak</TD> <TD>2588.50</TD> </TR> <TR> <TD>2022</TD> <TD>2</TD> <TD width="146">GFPL-Mfg.</TD> <TD>748.18</TD> </TR> <TR> <TD>2022</TD> <TD>2</TD> <TD width="146">GFPL-Trading</TD> <TD>331.36</TD> </TR> <TR> <TD>2022</TD> <TD>2</TD> <TD width="146">FP</TD> <TD>1216.37</TD> </TR> <TR> <TD>2022</TD> <TD>2</TD> <TD width="146">SKG</TD> <TD>1023.24</TD> </TR> <TR> <TD>2022</TD> <TD>2</TD> <TD width="146">Vizag</TD> <TD>1032.84</TD> </TR> <TR> <TD>2022</TD> <TD>3</TD> <TD width="146">B208+Chetak</TD> <TD>2343.99</TD> </TR> <TR> <TD>2022</TD> <TD>3</TD> <TD width="146">GFPL-Mfg.</TD> <TD>764.08</TD> </TR> <TR> <TD>2022</TD> <TD>3</TD> <TD width="146">GFPL-Trading</TD> <TD>358.39</TD> </TR> <TR> <TD>2022</TD> <TD>3</TD> <TD width="146">FP</TD> <TD>1097.33</TD> </TR> <TR> <TD>2022</TD> <TD>3</TD> <TD width="146">SKG</TD> <TD>1116.14</TD> </TR> <TR> <TD>2022</TD> <TD>3</TD> <TD width="146">Vizag</TD> <TD>1060.37</TD> </TR> <TR> <TD>2022</TD> <TD>4</TD> <TD width="146">B208+Chetak</TD> <TD>1881.43</TD> </TR> <TR> <TD>2022</TD> <TD>4</TD> <TD width="146">GFPL-Mfg.</TD> <TD>590.93</TD> </TR> <TR> <TD>2022</TD> <TD>4</TD> <TD width="146">GFPL-Trading</TD> <TD>250.33</TD> </TR> <TR> <TD>2022</TD> <TD>4</TD> <TD width="146">FP</TD> <TD>1059.26</TD> </TR> <TR> <TD>2022</TD> <TD>4</TD> <TD width="146">SKG</TD> <TD>924.98</TD> </TR> <TR> <TD>2022</TD> <TD>4</TD> <TD width="146">Vizag</TD> <TD>957.04</TD> </TR> <TR> <TD>2022</TD> <TD>5</TD> <TD width="146">B208+Chetak</TD> <TD>2431.42</TD> </TR> <TR> <TD>2022</TD> <TD>5</TD> <TD width="146">GFPL-Mfg.</TD> <TD>656.93</TD> </TR> <TR> <TD>2022</TD> <TD>5</TD> <TD width="146">GFPL-Trading</TD> <TD>213.97</TD> </TR> <TR> <TD>2022</TD> <TD>5</TD> <TD width="146">FP</TD> <TD>1076.88</TD> </TR> <TR> <TD>2022</TD> <TD>5</TD> <TD width="146">SKG</TD> <TD>1232.35</TD> </TR> <TR> <TD>2022</TD> <TD>5</TD> <TD width="146">Vizag</TD> <TD>996.91</TD> </TR> <TR> <TD>2022</TD> <TD>6</TD> <TD width="146">B208+Chetak</TD> <TD>2414.42</TD> </TR> <TR> <TD>2022</TD> <TD>6</TD> <TD width="146">GFPL-Mfg.</TD> <TD>598.39</TD> </TR> <TR> <TD>2022</TD> <TD>6</TD> <TD width="146">GFPL-Trading</TD> <TD>224.88</TD> </TR> <TR> <TD>2022</TD> <TD>6</TD> <TD width="146">FP</TD> <TD>1121.93</TD> </TR> <TR> <TD>2022</TD> <TD>6</TD> <TD width="146">SKG</TD> <TD>1221.98</TD> </TR> <TR> <TD>2022</TD> <TD>6</TD> <TD width="146">Vizag</TD> <TD>1026.44</TD> </TR> <TR> <TD>2022</TD> <TD>7</TD> <TD width="146">B208+Chetak</TD> <TD>1130.16</TD> </TR> <TR> <TD>2022</TD> <TD>7</TD> <TD width="146">GFPL-Mfg.</TD> <TD>429.00</TD> </TR> <TR> <TD>2022</TD> <TD>7</TD> <TD width="146">GFPL-Trading</TD> <TD>161.84</TD> </TR> <TR> <TD>2022</TD> <TD>7</TD> <TD width="146">FP</TD> <TD>832.22</TD> </TR> <TR> <TD>2022</TD> <TD>7</TD> <TD width="146">SKG</TD> <TD>1180.40</TD> </TR> <TR> <TD>2022</TD> <TD>7</TD> <TD width="146">Vizag</TD> <TD>912.60</TD> </TR> <TR> <TD>2022</TD> <TD>8</TD> <TD width="146">B208+Chetak</TD> <TD>1130.16</TD> </TR> <TR> <TD>2022</TD> <TD>8</TD> <TD width="146">GFPL-Mfg.</TD> <TD>429.00</TD> </TR> <TR> <TD>2022</TD> <TD>8</TD> <TD width="146">GFPL-Trading</TD> <TD>161.84</TD> </TR> <TR> <TD>2022</TD> <TD>8</TD> <TD width="146">FP</TD> <TD>832.22</TD> </TR> <TR> <TD>2022</TD> <TD>8</TD> <TD width="146">SKG</TD> <TD>1180.40</TD> </TR> <TR> <TD>2022</TD> <TD>8</TD> <TD width="146">Vizag</TD> <TD>912.60</TD> </TR> </TBODY> </TABLE> Sat, 10 Sep 2022 09:36:50 GMT https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979454#M1220940 Charu_1628 2022-09-10T09:36:50Z Re: Trailing Sales for 12 months https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979458#M1220941 <P>I'd create a Date in the script</P> <P><STRONG>MakeDate(Year,Month,1) as Date</STRONG></P> <P>Then use this expression</P> <P><STRONG> Sum({&lt;Date={"$(='&gt;=' &amp; Date(MonthStart(Max(Date), -12)) &amp; '&lt;' &amp; Date(MonthStart(Max(Date))))"}&gt;} Sales)</STRONG></P> <P>&nbsp;</P> Sat, 10 Sep 2022 11:07:24 GMT https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979458#M1220941 BrunPierre 2022-09-10T11:07:24Z Re: Trailing Sales for 12 months https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979459#M1220942 <P>Hey,Thanks .</P> <P>But it's not working properly.</P> <P>Actually, Suppose if I'm in September right now&nbsp; then its should reflect the values from Sep21-Aug22.</P> <P>this is not happening.</P> <P>&nbsp;</P> Sat, 10 Sep 2022 11:50:38 GMT https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979459#M1220942 Charu_1628 2022-09-10T11:50:38Z Re: Trailing Sales for 12 months https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979465#M1220943 <P><STRONG><FONT color="#000000">Sum({&lt;Date={"$(='&gt;=' &amp; Date(MonthStart(Max(Date),<FONT color="#FF0000"> -11</FONT>)) &amp; '&lt;' &amp; Date(MonthStart(Max(Date))))"}&gt;} Sales)</FONT></STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peter_brown_0-1662812814077.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/88846iFC567AD7F66DBD1F/image-size/medium?v=v2&amp;px=400" role="button" title="peter_brown_0-1662812814077.png" alt="peter_brown_0-1662812814077.png" /></span></P> <P>&nbsp;</P> Sat, 10 Sep 2022 12:28:41 GMT https://community.qlik.com/t5/QlikView/Trailing-Sales-for-12-months/m-p/1979465#M1220943 BrunPierre 2022-09-10T12:28:41Z