topic Re: Adding Conditions in QlikView https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925479#M320285 <HTML><HEAD></HEAD><BODY><P>Use a a straight table with :</P><P></P><P>Dimension:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Buyer</P><P></P><P>Expressions :</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum([Ammount])</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum([Daily Budget])</P></BODY></HTML> Mon, 14 Dec 2015 18:40:05 GMT Anonymous 2015-12-14T18:40:05Z Adding Conditions https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925478#M320284 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering if anyone could help with an issue im currently facing.</P><P>I need to add totals of ammount depeding on the guy that registred it.</P><P></P><P>For example, my data base looks like this.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Buyer</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Ammount</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>DailyBudget</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item Code</STRONG></TH></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">201</TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">202</TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">23</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">201</TD></TR><TR><TD style="padding: 2px;">B2</TD><TD style="padding: 2px;">34</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">203</TD></TR><TR><TD style="padding: 2px;">B2</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">201</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">201</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">34</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">203</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">21</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">202</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">11</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">202</TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">203</TD></TR></TBODY></TABLE><P></P><P>The tricky part is when i have to compare it to the daily budget.</P><P></P><P>Every buyer has his daily budget, sometimes is the same between different items and sometimes it isnt. I need a result kinda like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Buyer</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Ammount</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Daily Budget</TH></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">43</TD><TD style="padding: 2px;">95</TD></TR><TR><TD style="padding: 2px;">B2</TD><TD style="padding: 2px;">41</TD><TD style="padding: 2px;">60</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">74</TD><TD style="padding: 2px;">95</TD></TR></TBODY></TABLE><P></P><P>The daily budget for each one is the sum the daily budget of every different item code you have.</P><P></P><P>thanks for the help,</P><P>KR</P></BODY></HTML> Mon, 14 Dec 2015 18:35:34 GMT https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925478#M320284 2015-12-14T18:35:34Z Re: Adding Conditions https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925479#M320285 <HTML><HEAD></HEAD><BODY><P>Use a a straight table with :</P><P></P><P>Dimension:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Buyer</P><P></P><P>Expressions :</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum([Ammount])</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum([Daily Budget])</P></BODY></HTML> Mon, 14 Dec 2015 18:40:05 GMT https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925479#M320285 Anonymous 2015-12-14T18:40:05Z Re: Adding Conditions https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925480#M320286 <HTML><HEAD></HEAD><BODY><P>Try this expression for Daily Budget:</P><P></P><P><STRONG>=Sum(Aggr(Avg(DailyBudget), [Item Code], Buyer))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108981_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 14 Dec 2015 18:40:37 GMT https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925480#M320286 sunny_talwar 2015-12-14T18:40:37Z Re: Adding Conditions https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925481#M320287 <HTML><HEAD></HEAD><BODY><P>thanks, worked great <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 14 Dec 2015 18:56:31 GMT https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925481#M320287 2015-12-14T18:56:31Z Re: Adding Conditions https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925482#M320288 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 14 Dec 2015 19:02:27 GMT https://community.qlik.com/t5/QlikView/Adding-Conditions/m-p/925482#M320288 sunny_talwar 2015-12-14T19:02:27Z