topic Re: how to write expression in QlikView https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362884#M460032 <HTML><HEAD></HEAD><BODY><P>Sunny ,can u help me how to group the below&nbsp; column&nbsp; 460,30</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169778_Untitled.png" style="height: auto;" /></P><P></P><P><IMG alt="Untitled.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/169779_Untitled.png" style="height: auto;" /></P></BODY></HTML> Tue, 11 Jul 2017 13:00:25 GMT kunkumnaveen 2017-07-11T13:00:25Z how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362879#M460027 <HTML><HEAD></HEAD><BODY><P>HI,&nbsp; i got a sample data like below,</P><P></P><P><SPAN style="font-size: 10pt;">partt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; component12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; plant_code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vendor_code&nbsp;&nbsp; volumn&nbsp;&nbsp;&nbsp;&nbsp; unit_price</SPAN></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aaa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; yyy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bbb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; zzz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ccc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jjj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ddd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P></P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" height="85" src="https://community.qlik.com/legacyfs/online/169759_Untitled.png" style="height: 84.6919px; width: 761px;" width="761" /></P><P></P><P>i am able to display 35 only in one row ,how to display 35 in remaining two rows as well ,</P><P>Expression :<STRONG>aggr(sum(volumn),partt) ....what is wrong with his expression</STRONG></P><P></P><P></P><P>Thanks</P></BODY></HTML> Tue, 11 Jul 2017 12:29:22 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362879#M460027 kunkumnaveen 2017-07-11T12:29:22Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362880#M460028 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><STRONG>Sum(TOTAL &lt;partt&gt; volumn)</STRONG></P><P></P><P>or this</P><P><STRONG>Aggr(NODISTINCT Sum(volumn),partt)</STRONG></P></BODY></HTML> Tue, 11 Jul 2017 12:32:01 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362880#M460028 sunny_talwar 2017-07-11T12:32:01Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362881#M460029 <HTML><HEAD></HEAD><BODY><P>Because, Aggregation work only Group By condition</P><P>you can try somthing lke below</P><P></P><P class="m_-17145866231689250jive-rendered-content"></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aggr(NoDistinct sum(volumn),partt)</STRONG></P><DIV><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG><P></P></DIV></BODY></HTML> Tue, 11 Jul 2017 12:33:24 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362881#M460029 Anil_Babu_Samineni 2017-07-11T12:33:24Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362882#M460030 <HTML><HEAD></HEAD><BODY><P>Hello Sunny ,thanks for quick reply ,y do i am getting total as null<IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169775_Untitled.png" style="height: auto;" /></P></BODY></HTML> Tue, 11 Jul 2017 12:35:31 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362882#M460030 kunkumnaveen 2017-07-11T12:35:31Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362883#M460031 <HTML><HEAD></HEAD><BODY><P>Because you don't have an outer aggregation... May be add Sum()</P><P></P><P><STRONG>Sum(</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Aggr(NODISTINCT Sum(volumn),partt)) * ....</STRONG></P></BODY></HTML> Tue, 11 Jul 2017 12:36:50 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362883#M460031 sunny_talwar 2017-07-11T12:36:50Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362884#M460032 <HTML><HEAD></HEAD><BODY><P>Sunny ,can u help me how to group the below&nbsp; column&nbsp; 460,30</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169778_Untitled.png" style="height: auto;" /></P><P></P><P><IMG alt="Untitled.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/169779_Untitled.png" style="height: auto;" /></P></BODY></HTML> Tue, 11 Jul 2017 13:00:25 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362884#M460032 kunkumnaveen 2017-07-11T13:00:25Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362885#M460033 <HTML><HEAD></HEAD><BODY><P>Remove all dimensions except for partt</P></BODY></HTML> Tue, 11 Jul 2017 13:01:59 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362885#M460033 sunny_talwar 2017-07-11T13:01:59Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362886#M460034 <HTML><HEAD></HEAD><BODY><P>will it not possible by keeping dimensions</P></BODY></HTML> Tue, 11 Jul 2017 13:04:43 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362886#M460034 kunkumnaveen 2017-07-11T13:04:43Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362887#M460035 <HTML><HEAD></HEAD><BODY><P>You want to see two rows? which vendor_code should it show for A in the single row is shows for A?</P></BODY></HTML> Tue, 11 Jul 2017 13:06:58 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362887#M460035 sunny_talwar 2017-07-11T13:06:58Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362888#M460036 <HTML><HEAD></HEAD><BODY><P>what i need to show is a new column at the end </P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169780_Untitled.png" style="height: 65px; width: 620px;" /></P><P>each row&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new _column</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 460-420</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 460-420</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 460-560</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30-30</P></BODY></HTML> Tue, 11 Jul 2017 13:08:45 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362888#M460036 kunkumnaveen 2017-07-11T13:08:45Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362889#M460037 <HTML><HEAD></HEAD><BODY><P>Can you post your file... will be easier to work with a sample</P></BODY></HTML> Tue, 11 Jul 2017 13:11:15 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362889#M460037 sunny_talwar 2017-07-11T13:11:15Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362890#M460038 <HTML><HEAD></HEAD><BODY><P>what i tried to get new_column is:</P><P><STRONG>aggr(sum(sum(volumn )* sum(unit_price)),plant_code)-(Aggr(NODISTINCT Sum(volumn),partt) *&nbsp; sum(unit_price))</STRONG></P><P>but i am getting null</P></BODY></HTML> Tue, 11 Jul 2017 13:12:28 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362890#M460038 kunkumnaveen 2017-07-11T13:12:28Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362891#M460039 <HTML><HEAD></HEAD><BODY><P>Okay</P></BODY></HTML> Tue, 11 Jul 2017 13:14:13 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362891#M460039 sunny_talwar 2017-07-11T13:14:13Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362892#M460040 <HTML><HEAD></HEAD><BODY><P>sample file</P></BODY></HTML> Tue, 11 Jul 2017 13:15:46 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362892#M460040 kunkumnaveen 2017-07-11T13:15:46Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362893#M460041 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>sum(TOTAL &lt;partt&gt; volumn * unit_price) - Aggr(NODISTINCT Sum(volumn),partt) *&nbsp; sum(unit_price)</STRONG></P></BODY></HTML> Tue, 11 Jul 2017 13:19:05 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362893#M460041 sunny_talwar 2017-07-11T13:19:05Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362894#M460042 <HTML><HEAD></HEAD><BODY><P>perfect ,thanks a lot</P></BODY></HTML> Tue, 11 Jul 2017 13:22:58 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1362894#M460042 kunkumnaveen 2017-07-11T13:22:58Z