topic Re: When I display value in expression it doubled the value? Why? in QlikView https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373848#M494109 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>Yes most of the cases for occuring multiple values is having problem with when creating the datasource .</P><P></P><P>I too also faced such kind of problem after lots of test case i came to know that the data in the datasource itself having the mutliple values.</P><P></P><P>Regards<BR />venkat</P></BODY></HTML> Mon, 30 Apr 2012 09:49:49 GMT 2012-04-30T09:49:49Z When I display value in expression it doubled the value? Why? https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373845#M494106 <HTML><HEAD></HEAD><BODY><P>Please look at the picture, the one in dimension displays correct value, while the one in expression, doubled the value, how to fix this?</P><P></P><P><IMG __jive_id="13594" alt="why.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/13594_why.png" width="450" /></P><P></P><P>Please help. Thanks in advance.</P><P></P><P>-Bill here</P></BODY></HTML> Mon, 30 Apr 2012 09:20:00 GMT https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373845#M494106 2012-04-30T09:20:00Z Why when I display value in expression it doubled? https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373846#M494107 <HTML><HEAD></HEAD><BODY><P>Hi Bill,</P><P></P><P>Try expression : sum(DISTINCT sr.qty_returned)</P><P></P><P>Also check your data source for duplicate value.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 30 Apr 2012 09:23:00 GMT https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373846#M494107 Sokkorn 2012-04-30T09:23:00Z When I display value in expression it doubled the value? Why? https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373847#M494108 <HTML><HEAD></HEAD><BODY><P>In some parameters or query, it display correct data, so maybe it's in the datasource.</P></BODY></HTML> Mon, 30 Apr 2012 09:40:23 GMT https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373847#M494108 2012-04-30T09:40:23Z Re: When I display value in expression it doubled the value? Why? https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373848#M494109 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>Yes most of the cases for occuring multiple values is having problem with when creating the datasource .</P><P></P><P>I too also faced such kind of problem after lots of test case i came to know that the data in the datasource itself having the mutliple values.</P><P></P><P>Regards<BR />venkat</P></BODY></HTML> Mon, 30 Apr 2012 09:49:49 GMT https://community.qlik.com/t5/QlikView/When-I-display-value-in-expression-it-doubled-the-value-Why/m-p/373848#M494109 2012-04-30T09:49:49Z