topic Re: experssion in QlikView https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724654#M1086391 <HTML><HEAD></HEAD><BODY><P>Total Sale for each year-month = unit of price * Number of sale ( for 201401 - 201402 - 201403 ,.......)</P></BODY></HTML> Mon, 23 Jun 2014 06:53:34 GMT 2014-06-23T06:53:34Z Experssion for multiple price per article https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724652#M1086388 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 5</STRONG></TH></TR><TR><TD style="padding: 2px;">Article</TD><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" width="81"><TBODY><TR><TD class="xl65" height="45" style="height: 33.75pt; width: 61pt;" width="81">Year-Month</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" width="86"><TBODY><TR><TD class="xl65" height="45" style="height: 33.75pt; width: 65pt;" width="86">Unit of Price</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" width="107"><TBODY><TR><TD class="xl65" height="45" style="height: 33.75pt; width: 80pt;" width="107">Number of sale</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" width="86"><TBODY><TR><TD class="xl65" height="45" style="height: 33.75pt; width: 65pt;" width="86">Total of sale</TD></TR></TBODY></TABLE></TD></TR><TR><TD style="padding: 2px;">1234</TD><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" width="81"><TBODY><TR><TD class="xl65" height="19" style="height: 14.25pt; width: 61pt;" width="81">201401</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">1234</TD><TD style="padding: 2px;">201402</TD><TD style="padding: 2px;">1100</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">1234</TD><TD style="padding: 2px;">201403</TD><TD style="padding: 2px;">1200</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Dear Friends</P><P>I need an experssion for Total of sale (for each Year-Month).</P></BODY></HTML> Mon, 23 Jun 2014 06:47:50 GMT https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724652#M1086388 2014-06-23T06:47:50Z Re: experssion https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724653#M1086389 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What is the definition of total sale as per you.</P><P></P><P>Is it like.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Total Sale = Unit of Price * <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Number of </SPAN><SPAN class="bqwdw16" style="border-top-color: transparent; border-right-color: transparent; border-left-color: transparent; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-decoration: underline; color: #009900 !important;">sale or what?</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN class="bqwdw16" style="border-top-color: transparent; border-right-color: transparent; border-left-color: transparent; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-decoration: underline; color: #009900 !important;"><BR /></SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN class="bqwdw16" style="border-top-color: transparent; border-right-color: transparent; border-left-color: transparent; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-decoration: underline; color: #009900 !important;"><BR /></SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN class="bqwdw16" style="border-top-color: transparent; border-right-color: transparent; border-left-color: transparent; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-decoration: underline; color: #009900 !important;">Regards</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN class="bqwdw16" style="border-top-color: transparent; border-right-color: transparent; border-left-color: transparent; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-decoration: underline; color: #009900 !important;">ASHFAQ<BR /></SPAN></SPAN></P></BODY></HTML> Mon, 23 Jun 2014 06:50:10 GMT https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724653#M1086389 ashfaq_haseeb 2014-06-23T06:50:10Z Re: experssion https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724654#M1086391 <HTML><HEAD></HEAD><BODY><P>Total Sale for each year-month = unit of price * Number of sale ( for 201401 - 201402 - 201403 ,.......)</P></BODY></HTML> Mon, 23 Jun 2014 06:53:34 GMT https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724654#M1086391 2014-06-23T06:53:34Z Re: experssion https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724655#M1086392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There is issue with your data model.</P><P>If you select some value in your field Year Month, There is no possible association in field Fe which I believe is unit price. </P><P>Please fix your data-model</P><P></P><P>Hope it help </P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 23 Jun 2014 07:05:01 GMT https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724655#M1086392 ashfaq_haseeb 2014-06-23T07:05:01Z Re: experssion https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724656#M1086393 <HTML><HEAD></HEAD><BODY><P>Thanks , I fixed data model , but i have duplicate values yet and i don't know how use "SUM IF" for calculate total sale for each year-month.</P></BODY></HTML> Mon, 23 Jun 2014 07:14:12 GMT https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724656#M1086393 2014-06-23T07:14:12Z Re: experssion https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724657#M1086394 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Are those duplicate values cumming from Database?</P><P>If not then need to look at the data model.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 23 Jun 2014 07:16:26 GMT https://community.qlik.com/t5/QlikView/Experssion-for-multiple-price-per-article/m-p/724657#M1086394 ashfaq_haseeb 2014-06-23T07:16:26Z