topic Re: Problem with create correct expression. in QlikView https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366984#M418243 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>I have flex table to this </P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>What is a flex table?</P></BODY></HTML> Tue, 27 Jun 2017 14:55:09 GMT sunny_talwar 2017-06-27T14:55:09Z Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366978#M418237 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have 2 transaction tables (Sales,Prognoz in attachment) . They include different type of clients (Client - Client_main). </P><P>Mapping table for Client - Client_main in attachment too.</P><P>Else, i have table for client classes.</P><P>I create data model from this xls files. For example,It has few same rows (prognoz in transactions) for 1 main client, because one main client mapping for few clients.</P><P>I want, that expression for prognoz working correctly. Now, in attachment app. it increases threefold</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168272_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>How can i fix it? </P><P></P><P></P><P>Thank you for your reply!</P><P>Anton Aleksandrov.</P></BODY></HTML> Tue, 27 Jun 2017 14:22:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366978#M418237 asgardd2 2017-06-27T14:22:33Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366979#M418238 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>=Sum({&lt;Type_Of_Transaction = {"Prognoz"}&gt;} Account)/Count(DISTINCT Class)</STRONG></P></BODY></HTML> Tue, 27 Jun 2017 14:27:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366979#M418238 sunny_talwar 2017-06-27T14:27:57Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366980#M418239 <HTML><HEAD></HEAD><BODY><P>Hi Aleksandrov,</P><P>have You trie Sum( <STRONG style="color: #ff0000;">DISTINCT</STRONG> value) ?</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 27 Jun 2017 14:29:45 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366980#M418239 antoniotiman 2017-06-27T14:29:45Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366981#M418240 <HTML><HEAD></HEAD><BODY><P>Hello! Yes, i tried this, but o<SPAN class="short_text" lang="en"><SPAN>n a lot of data it works very slowly. </SPAN></SPAN></P></BODY></HTML> Tue, 27 Jun 2017 14:33:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366981#M418240 asgardd2 2017-06-27T14:33:02Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366982#M418241 <HTML><HEAD></HEAD><BODY><P>How about this?</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Sum({&lt;Type_Of_Transaction = {"Prognoz"}&gt;} Account)/Count(DISTINCT Class)</STRONG></P></BODY></HTML> Tue, 27 Jun 2017 14:34:17 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366982#M418241 sunny_talwar 2017-06-27T14:34:17Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366983#M418242 <HTML><HEAD></HEAD><BODY><P>Hello, Sunny!</P><P>I have flex table to this and It is not working correctly in other selections. (and dimensions)</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168274_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/168284_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 27 Jun 2017 14:47:11 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366983#M418242 asgardd2 2017-06-27T14:47:11Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366984#M418243 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>I have flex table to this </P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>What is a flex table?</P></BODY></HTML> Tue, 27 Jun 2017 14:55:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366984#M418243 sunny_talwar 2017-06-27T14:55:09Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366985#M418244 <HTML><HEAD></HEAD><BODY><P>I mean table, that i load in script via inline load.</P><P>After that, i use this table to choose dimensions(show condition) in "Straight table".</P></BODY></HTML> Tue, 27 Jun 2017 15:07:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366985#M418244 asgardd2 2017-06-27T15:07:42Z Re: Problem with create correct expression. https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366986#M418245 <HTML><HEAD></HEAD><BODY><P>I have solution (working very slowly) with using DISTINCT:</P><P>IF(Dimensionality() = 0,</P><P>Sum(Aggr(Sum(DISTINCT {&lt;Type_Of_Transaction = {"Prognoz"}&gt;} Account),Client_main,Product)),</P><P>Sum(Aggr(Sum(DISTINCT {&lt;Type_Of_Transaction = {"Prognoz"}&gt;} Account),<SPAN style="font-size: 13.3333px;">Client_main,Product,</SPAN><STRONG>!!! dimensions in table !!!</STRONG> ))</P><P></P><P><IMG alt="999.png" class="jive-image image-1" height="267" src="https://community.qlik.com/legacyfs/online/168386_999.png" style="height: 267px; width: 1118.51px;" width="1119" /></P></BODY></HTML> Wed, 28 Jun 2017 07:37:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-create-correct-expression/m-p/1366986#M418245 asgardd2 2017-06-28T07:37:31Z