topic Re: Total with set analysis in QlikView https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459658#M171578 <HTML><HEAD></HEAD><BODY><P>sorry, I´ve got only 0 values</P></BODY></HTML> Wed, 15 May 2013 19:14:19 GMT rcandeo 2013-05-15T19:14:19Z Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459652#M171572 <HTML><HEAD></HEAD><BODY><P>Hi, I have this expression:</P><P></P><P>if(sum(Quantity_budget) &gt; 0, sum({&lt;Salesman = {'John'}&gt;} Quantity_Sales),0)</P><P></P><P>where i intend to show the amount of sales, only for the SKUs that are on the budget.</P><P></P><P>It Works, but I need the total, and if I put the SKU to summarize in the dimension, the total summarizes all the lines, not only the ones that have budget.</P><P></P><P>Anyone can give me a hint please?</P><P></P><P>Robson</P></BODY></HTML> Tue, 14 May 2013 18:32:46 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459652#M171572 rcandeo 2013-05-14T18:32:46Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459653#M171573 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">if(sum(Quantity_budget) &gt; 0, sum({&lt;Salesman = {'John'}&gt;} total Quantity_Sales),0)</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">If i understand it correctly.</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Tue, 14 May 2013 19:48:24 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459653#M171573 2013-05-14T19:48:24Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459654#M171574 <HTML><HEAD></HEAD><BODY><P>Unfortunately total is not the answer. Instead giving me the final total correct, it gaves me the final total in all lines.</P><P></P><P>Any other idea please?</P></BODY></HTML> Wed, 15 May 2013 12:34:46 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459654#M171574 rcandeo 2013-05-15T12:34:46Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459655#M171575 <HTML><HEAD></HEAD><BODY><P>Try his</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">sum(if(Quantity_budget&gt; 0, sum({&lt;Salesman = {'John'}&gt;} Quantity_Sales),0))</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">hope it helps<BR /></SPAN></P></BODY></HTML> Wed, 15 May 2013 12:38:28 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459655#M171575 er_mohit 2013-05-15T12:38:28Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459656#M171576 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I think you can try this:</P><P></P><P>sum(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">{$&lt;Quantity_budget={'&gt;0'},Salesman = {'John'}&gt;} </SPAN>Quantity_Sales)</P><P></P><P>Kind Regards,</P><P></P><P>Cesar</P></BODY></HTML> Wed, 15 May 2013 12:38:30 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459656#M171576 cesaraccardi 2013-05-15T12:38:30Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459657#M171577 <HTML><HEAD></HEAD><BODY><P>I think</P><P>your code is fine. you want the total which is display in all lines.</P><P>so take a straight table and then go to its properties then presentation tab,, check total on first row(bydefault).</P><P>hope this helps you</P></BODY></HTML> Wed, 15 May 2013 12:53:41 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459657#M171577 2013-05-15T12:53:41Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459658#M171578 <HTML><HEAD></HEAD><BODY><P>sorry, I´ve got only 0 values</P></BODY></HTML> Wed, 15 May 2013 19:14:19 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459658#M171578 rcandeo 2013-05-15T19:14:19Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459659#M171579 <HTML><HEAD></HEAD><BODY><P>sorry, I´ve got only 0 values</P></BODY></HTML> Wed, 15 May 2013 19:14:28 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459659#M171579 rcandeo 2013-05-15T19:14:28Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459660#M171580 <HTML><HEAD></HEAD><BODY><P>Sorry, Now I got the same total in the above line.</P><P></P><P>Let me show an example and maybe you understand me.</P><P>Look at my totals. They are bigger cause I have some sales in lines that don´t have budget, so I don´t wanna the to be showed and don´t wanna to be summarized too.</P><P></P><TABLE><TBODY><TR><TD>Place</TD><TD>Group</TD><TD>SKU</TD><TD>Budget</TD><TD>Sales</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851624</TD><TD>9,20</TD><TD>9,20</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851823</TD><TD>36,64</TD><TD>189,29</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851831</TD><TD>1,68</TD><TD>155,65</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851841</TD><TD>3.064,38</TD><TD>2.549,71</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851902</TD><TD>55,98</TD><TD>64,11</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851971</TD><TD>118,81</TD><TD>122,12</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852027</TD><TD>19,84</TD><TD>19,84</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852034</TD><TD>6,36</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852054</TD><TD>54,95</TD><TD>27,48</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852056</TD><TD>64,10</TD><TD>22,44</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852109</TD><TD>21,36</TD><TD>21,37</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852162</TD><TD>22,61</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852164</TD><TD>3,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852352</TD><TD>3,05</TD><TD>3,05</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852354</TD><TD>19,23</TD><TD>19,23</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852399</TD><TD>1,53</TD><TD>1,53</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852406</TD><TD>57,69</TD><TD>32,05</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852471</TD><TD>22,22</TD><TD>21,37</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852585</TD><TD>183,15</TD><TD>164,86</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852588</TD><TD>9,62</TD><TD>9,62</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852718</TD><TD>247,26</TD><TD>250,35</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852721</TD><TD>115,38</TD><TD>115,38</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852809</TD><TD>3,05</TD><TD>3,05</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852812</TD><TD>3,21</TD><TD>3,21</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852925</TD><TD>48,59</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852928</TD><TD>23,12</TD><TD>22,44</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>853136</TD><TD>28,94</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>853236</TD><TD>9,62</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>877499</TD><TD>1,53</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>877503</TD><TD>9,16</TD><TD>18,31</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890633</TD><TD>1,53</TD><TD>1,53</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890636</TD><TD>122,10</TD><TD>122,12</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890638</TD><TD>54,28</TD><TD>54,49</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890647</TD><TD>81,87</TD><TD>83,50</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890649</TD><TD>3,21</TD><TD>3,57</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890659</TD><TD>51,38</TD><TD>12,21</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890679</TD><TD>78,57</TD><TD>128,23</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890683</TD><TD>3,21</TD><TD>38,46</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890713</TD><TD>65,08</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890715</TD><TD>59,45</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890731</TD><TD>1,53</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890733</TD><TD>229,87</TD><TD>170,97</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890888</TD><TD>29,00</TD><TD>28,99</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890890</TD><TD>79,93</TD><TD>79,38</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890892</TD><TD>102,46</TD><TD>102,56</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890909</TD><TD>176,08</TD><TD>183,18</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890911</TD><TD>136,19</TD><TD>128,20</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890941</TD><TD>6,10</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890943</TD><TD>122,02</TD><TD>122,12</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890945</TD><TD>70,81</TD><TD>70,51</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>894018</TD><TD>24,25</TD><TD>3,05</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>894023</TD><TD>6,10</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895036</TD><TD>129,67</TD><TD>116,01</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895166</TD><TD>19,84</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895263</TD><TD>3,05</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895269</TD><TD>3,05</TD><TD>3,05</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895271</TD><TD>3,05</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>990315</TD><TD>18,31</TD><TD>36,62</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>Total</TD><TD>5.947,42</TD><TD>6.118,37</TD></TR><TR><TD>XX02</TD><TD>sweet</TD><TD>989868</TD><TD>1.678,43</TD><TD>1.388,07</TD></TR><TR><TD>XX02</TD><TD>sweet</TD><TD>989874</TD><TD>1.228,50</TD><TD>77,22</TD></TR><TR><TD>XX02</TD><TD>sweet</TD><TD>Total</TD><TD>2.906,93</TD><TD>2.847,82</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805906</TD><TD>650,27</TD><TD>1.558,49</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805912</TD><TD>900,00</TD><TD>59,52</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805917</TD><TD>114,84</TD><TD>788,74</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805919</TD><TD>903,58</TD><TD>734,35</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805991</TD><TD>3.100,00</TD><TD>3.785,55</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805993</TD><TD>2.858,00</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>Total</TD><TD>8.526,69</TD><TD>17.639,47</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851666</TD><TD>6,14</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851783</TD><TD>39,69</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851785</TD><TD>67,31</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851831</TD><TD>12,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851841</TD><TD>1.648,35</TD><TD>125,17</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851843</TD><TD>1.192,31</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851847</TD><TD>6,11</TD><TD>225,85</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>851971</TD><TD>235,04</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852162</TD><TD>21,37</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852164</TD><TD>3,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852207</TD><TD>3,05</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852213</TD><TD>33,58</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852215</TD><TD>3,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852352</TD><TD>9,16</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852354</TD><TD>19,23</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852406</TD><TD>96,15</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852471</TD><TD>21,37</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852585</TD><TD>405,95</TD><TD>51,90</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852692</TD><TD>33,58</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852693</TD><TD>3,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852714</TD><TD>62,58</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852718</TD><TD>233,49</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852721</TD><TD>98,09</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852753</TD><TD>63,80</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852756</TD><TD>9,62</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852824</TD><TD>62,58</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852829</TD><TD>12,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852832</TD><TD>22,44</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852834</TD><TD>7,63</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852837</TD><TD>1,53</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852866</TD><TD>55,48</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852869</TD><TD>30,71</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852990</TD><TD>76,31</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>852993</TD><TD>3,21</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>853041</TD><TD>29,00</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>853043</TD><TD>33,58</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>877503</TD><TD>18,31</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890633</TD><TD>21,90</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890636</TD><TD>132,65</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890638</TD><TD>57,30</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890647</TD><TD>77,73</TD><TD>76,33</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890649</TD><TD>63,25</TD><TD>64,10</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890659</TD><TD>51,38</TD><TD>39,69</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890661</TD><TD>46,66</TD><TD>35,26</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890701</TD><TD>18,84</TD><TD>18,32</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890703</TD><TD>38,05</TD><TD>19,23</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890713</TD><TD>65,08</TD><TD>33,58</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890715</TD><TD>59,45</TD><TD>60,90</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890890</TD><TD>80,29</TD><TD>79,38</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890892</TD><TD>79,43</TD><TD>54,49</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>890935</TD><TD>107,17</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>894018</TD><TD>23,47</TD><TD>22,89</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>894022</TD><TD>21,39</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895036</TD><TD>117,09</TD><TD>61,06</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895119</TD><TD>18,31</TD><TD>12,21</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895128</TD><TD>137,11</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895166</TD><TD>1,53</TD><TD>15,26</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>895255</TD><TD>1,53</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>906014</TD><TD>6,11</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>923105</TD><TD>24,42</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>923106</TD><TD>6,10</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Melsugar</TD><TD>Total</TD><TD>5.936,95</TD><TD>1.058,82</TD></TR><TR><TD>XX02</TD><TD>sweet</TD><TD>989868</TD><TD>1.866,11</TD><TD>81,44</TD></TR><TR><TD>XX02</TD><TD>sweet</TD><TD>989874</TD><TD>842,40</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>sweet</TD><TD>Total</TD><TD>2.708,51</TD><TD>198,43</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805904</TD><TD>34,07</TD><TD>122,08</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805917</TD><TD>193,41</TD><TD>417,04</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805919</TD><TD>903,58</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805920</TD><TD>300,00</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805922</TD><TD>461,81</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805924</TD><TD>412,16</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805926</TD><TD>545,80</TD><TD>0,00</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805991</TD><TD>5.140,00</TD><TD>819,93</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>805993</TD><TD>800,00</TD><TD>123,90</TD></TR><TR><TD>XX02</TD><TD>Standard</TD><TD>Total</TD><TD>8.790,81</TD><TD>3.442,81</TD></TR><TR><TD>XX02</TD><TD><BR /></TD><TD><BR /></TD><TD>34.817,31</TD><TD>1.993.465,72</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>805680</TD><TD>83,16</TD><TD>232,16</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>805682</TD><TD>293,88</TD><TD>2.371,40</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>805685</TD><TD>3.804,25</TD><TD>1.962,48</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>805688</TD><TD>473,14</TD><TD>316,59</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>805729</TD><TD>400,00</TD><TD>393,89</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>Total</TD><TD>5.054,43</TD><TD>11.771,34</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>856146</TD><TD>6,24</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>856188</TD><TD>3,12</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923124</TD><TD>34,31</TD><TD>24,95</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923162</TD><TD>84,21</TD><TD>68,62</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923281</TD><TD>9,96</TD><TD>9,96</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923283</TD><TD>23,25</TD><TD>23,25</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923456</TD><TD>374,28</TD><TD>455,46</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>Total</TD><TD>535,37</TD><TD>1.125,65</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>969408</TD><TD>141,06</TD><TD>145,76</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>988500</TD><TD>72,88</TD><TD>72,88</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>Total</TD><TD>213,94</TD><TD>218,64</TD></TR><TR><TD>XX06</TD><TD>Diet</TD><TD>989176</TD><TD>47,15</TD><TD>85,72</TD></TR><TR><TD>XX06</TD><TD>Diet</TD><TD>989196</TD><TD>62,30</TD><TD>79,74</TD></TR><TR><TD>XX06</TD><TD>Diet</TD><TD>Total</TD><TD>109,45</TD><TD>3.228,72</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>805839</TD><TD>284,09</TD><TD>226,59</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>805841</TD><TD>896,56</TD><TD>1.098,46</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>900630</TD><TD>1.764,18</TD><TD>1.065,04</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>989997</TD><TD>184,85</TD><TD>182,81</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>992081</TD><TD>310,46</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>992085</TD><TD>308,45</TD><TD>289,70</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>Total</TD><TD>3.748,59</TD><TD>8.790,89</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805878</TD><TD>9,10</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805936</TD><TD>12,47</TD><TD>232,85</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805938</TD><TD>703,63</TD><TD>356,34</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805954</TD><TD>274,65</TD><TD>388,84</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>934016</TD><TD>103,08</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>934022</TD><TD>103,99</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>934032</TD><TD>104,48</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>992087</TD><TD>102,37</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>992092</TD><TD>101,27</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>992094</TD><TD>335,14</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>Total</TD><TD>1.850,19</TD><TD>3.678,55</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>805685</TD><TD>3.079,96</TD><TD>1.738,30</TD></TR><TR><TD>XX06</TD><TD>XXO</TD><TD>Total</TD><TD>3.079,96</TD><TD>3.914,02</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>856146</TD><TD>9,36</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>856221</TD><TD>65,50</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>856461</TD><TD>9,36</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>886984</TD><TD>37,43</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>887306</TD><TD>30,88</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>887323</TD><TD>36,18</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>887327</TD><TD>15,16</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>887330</TD><TD>10,81</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>887336</TD><TD>21,22</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>887358</TD><TD>3,60</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923112</TD><TD>9,36</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923121</TD><TD>12,48</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923124</TD><TD>65,50</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923253</TD><TD>16,61</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923283</TD><TD>16,61</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>923456</TD><TD>118,52</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Melsugar</TD><TD>Total</TD><TD>478,56</TD><TD>166,26</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>969408</TD><TD>4,70</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>982054</TD><TD>56,42</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>988500</TD><TD>230,40</TD><TD>152,82</TD></TR><TR><TD>XX06</TD><TD>Browsugar</TD><TD>Total</TD><TD>291,52</TD><TD>152,82</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>805835</TD><TD>9,67</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>805839</TD><TD>209,68</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>805841</TD><TD>475,66</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>822546</TD><TD>200,00</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>900630</TD><TD>2.822,69</TD><TD>2.172,56</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>989997</TD><TD>184,85</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>sweet</TD><TD>Total</TD><TD>3.902,55</TD><TD>2.982,15</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805878</TD><TD>118,29</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805897</TD><TD>282,06</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805936</TD><TD>374,22</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805938</TD><TD>970,33</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805954</TD><TD>413,52</TD><TD>348,72</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>805958</TD><TD>117,78</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>934022</TD><TD>103,99</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>934032</TD><TD>104,48</TD><TD>0,00</TD></TR><TR><TD>XX06</TD><TD>Standard</TD><TD>Total</TD><TD>2.484,66</TD><TD>1.100,82</TD></TR><TR><TD>XX06</TD><TD><BR /></TD><TD><BR /></TD><TD>21.749,22</TD><TD>58.555,54</TD></TR><TR><TD>Total</TD><TD><BR /></TD><TD><BR /></TD><TD>56.566,54</TD><TD>8.964.359,55</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 15 May 2013 19:22:46 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459660#M171580 rcandeo 2013-05-15T19:22:46Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459661#M171581 <HTML><HEAD></HEAD><BODY><P>All rows have a budget??? </P></BODY></HTML> Wed, 15 May 2013 19:33:04 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459661#M171581 2013-05-15T19:33:04Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459662#M171582 <HTML><HEAD></HEAD><BODY><P>Cesar almost had I think.</P><P></P><P>sum(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">{$&lt;Quantity_budget-={'0'},Salesman = {'John'}&gt;} TOTAL </SPAN>Quantity_Sales)</P><P></P><P>You need the dash before the equals and after budget to exclude values = to 0 in budget.</P></BODY></HTML> Wed, 15 May 2013 19:41:30 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459662#M171582 jpapador 2013-05-15T19:41:30Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459663#M171583 <HTML><HEAD></HEAD><BODY><P>No, some don´t have budget. That´s my problem.</P></BODY></HTML> Wed, 15 May 2013 20:20:09 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459663#M171583 rcandeo 2013-05-15T20:20:09Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459664#M171584 <HTML><HEAD></HEAD><BODY><P>I don´t know why I get only zeroes with this expression</P></BODY></HTML> Wed, 15 May 2013 20:28:16 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459664#M171584 rcandeo 2013-05-15T20:28:16Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459665#M171585 <HTML><HEAD></HEAD><BODY><P>At this point I think it may be easier to do in the script.&nbsp; Try this:</P><P></P><P>Left Join (to the table with SKUs)</P><P>LOAD</P><P>KeyFromSKUsTable,</P><P>SKU as SKU2</P><P>Resident SKU Table</P><P>Where Quantity_budget &gt; 0 and</P><P>Len(Quantity_budget) &gt; 0;</P><P></P><P>That will give you a second SKU field that has a budget associated that isnt null or 0.&nbsp; Then your expression can look like:</P><P></P><P>Sum({$&lt;Salesperson={'John'}&gt;}TOTAL SKU2)</P></BODY></HTML> Wed, 15 May 2013 20:40:00 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459665#M171585 jpapador 2013-05-15T20:40:00Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459666#M171586 <HTML><HEAD></HEAD><BODY><P>Can you upload a qvw for us to see, just a data reduced one with an example of the not working part?</P></BODY></HTML> Wed, 15 May 2013 23:53:39 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459666#M171586 calvindk 2013-05-15T23:53:39Z Re: Total with set analysis https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459667#M171587 <HTML><HEAD></HEAD><BODY><P>Try changing your total mode to "Sum of rows" instead of Expression Default. </P><P></P><P>Rob</P></BODY></HTML> Thu, 16 May 2013 03:19:15 GMT https://community.qlik.com/t5/QlikView/Total-with-set-analysis/m-p/459667#M171587 rwunderlich 2013-05-16T03:19:15Z