topic Re: sum (values0*value1) question in QlikView https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650639#M237956 <HTML><HEAD></HEAD><BODY><P>Hi, in Lithuanian Locale it is numeric field. thanks</P></BODY></HTML> Fri, 17 Oct 2014 12:24:51 GMT 2014-10-17T12:24:51Z sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650635#M237952 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>i am having some issues with following situation, data table:</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>name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>price</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>rate</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">0,5</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">0,5</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">0,9</TD></TR></TBODY></TABLE><P></P><P>I am trying to use expression in chart, to have total amount of rows, which is equal to price*rate. I am ussing expression SUM (price*rate), which gives me totaly wrong results.</P><P></P><P>Any suggestions?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 17 Oct 2014 11:21:36 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650635#M237952 2014-10-17T11:21:36Z Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650636#M237953 <HTML><HEAD></HEAD><BODY><P>Your rate is having a comma instead of decimal....so it is not a number anymore.</P><P></P><P>Thanks,</P><P>Singh</P></BODY></HTML> Fri, 17 Oct 2014 11:23:34 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650636#M237953 2014-10-17T11:23:34Z Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650637#M237954 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please attach your file</P><P></P><P>Thanks</P></BODY></HTML> Fri, 17 Oct 2014 11:26:05 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650637#M237954 d_pranskus 2014-10-17T11:26:05Z Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650638#M237955 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Take a look on the attached file.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Fri, 17 Oct 2014 11:31:19 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650638#M237955 Anonymous 2014-10-17T11:31:19Z Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650639#M237956 <HTML><HEAD></HEAD><BODY><P>Hi, in Lithuanian Locale it is numeric field. thanks</P></BODY></HTML> Fri, 17 Oct 2014 12:24:51 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650639#M237956 2014-10-17T12:24:51Z Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650640#M237957 <HTML><HEAD></HEAD><BODY><P>this works, but if I create one chart like this (table), i want to create other chart (bar graph) which uses sum of these Value 2 fields. And I cannot select this expression.</P><P>Formula in Value1 - shows incorect results.</P></BODY></HTML> Fri, 17 Oct 2014 12:26:44 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650640#M237957 2014-10-17T12:26:44Z Re: Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650641#M237958 <HTML><HEAD></HEAD><BODY><P>files attached.</P></BODY></HTML> Fri, 17 Oct 2014 12:32:14 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650641#M237958 2014-10-17T12:32:14Z Re: Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650642#M237959 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I've changed a few things. Take a look again, please.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Fri, 17 Oct 2014 12:40:54 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650642#M237959 Anonymous 2014-10-17T12:40:54Z Re: Re: Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650643#M237960 <HTML><HEAD></HEAD><BODY><P>no luck.</P><P></P><P>please see updated file, also with some examples of calculation in .xls sheet 2</P></BODY></HTML> Fri, 17 Oct 2014 14:36:05 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650643#M237960 2014-10-17T14:36:05Z Re: sum (values0*value1) question https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650644#M237961 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Expression should be as follows <STRONG>SUM(untaxed_amount_cache / rate)</STRONG></P><P><STRONG><BR /></STRONG></P><P>See attached<STRONG><BR /></STRONG></P><P></P><P>Cheers</P></BODY></HTML> Mon, 20 Oct 2014 23:33:49 GMT https://community.qlik.com/t5/QlikView/sum-values0-value1-question/m-p/650644#M237961 d_pranskus 2014-10-20T23:33:49Z