topic Re: how to write expressions in QlikView https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306026#M460647 <HTML><HEAD></HEAD><BODY><P>Hello Rahul,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Appreciated for your help bro.....</P></BODY></HTML> Tue, 25 Apr 2017 04:13:16 GMT kunkumnaveen 2017-04-25T04:13:16Z how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306012#M460633 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">hello,let say i have date like below</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">supplier&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value</SPAN></P><P style="font-size: 13.3333px;">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P style="font-size: 13.3333px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P style="font-size: 13.3333px;">C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P style="font-size: 13.3333px;">D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P style="font-size: 13.3333px;">J&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; chemical&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P style="font-size: 13.3333px;">L&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sugar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P style="font-size: 13.3333px;">M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sugar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P style="font-size: 13.3333px;">...............................</P><P style="font-size: 13.3333px;">...............................</P><P style="font-size: 13.3333px;">.................. so on</P><P style="font-size: 13.3333px;">let say i got thousands of supplier</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i want to display only those parts which&nbsp; has been supplier by more then one Supplier and i want to show % of that particular supplier among other supplier who supplies same parts.i mean</P><P style="font-size: 13.3333px;">supplier&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; part&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %of that supplier</P><P style="font-size: 13.3333px;">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100/100+200+300+400</P><P style="font-size: 13.3333px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2<SPAN style="font-size: 13.3333px;">00/100+200+300+400</SPAN></P><P style="font-size: 13.3333px;">C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3<SPAN style="font-size: 13.3333px;">00/100+200+300+400</SPAN></P><P style="font-size: 13.3333px;">D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<SPAN style="font-size: 13.3333px;">00/100+200+300+400</SPAN></P><P style="font-size: 13.3333px;">L&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sugar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500/1000+500</P><P style="font-size: 13.3333px;">M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sugar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000/1000+500</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG>Note :i dont want to display chemical because it is supplied by only one supplier</STRONG></P><P style="font-size: 13.3333px;">so what expressions <SPAN style="font-size: 13.3333px;">do i need write</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I tried this in calculated dimension to display only those parts which has multiple supplier</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">1)</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG>if(count(distinct supplier)&gt;1,part)&nbsp; (Invalid dimension error)</STRONG></SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">2)<SPAN style="font-size: 13.3333px;">%of that supplier</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG>sum(<SPAN style="font-size: 13.3333px;">%of that supplier</SPAN>)/sum(total <SPAN style="font-size: 13.3333px;">%of that supplier</SPAN>) </STRONG></P><P style="font-size: 13.3333px;">which is also wrong</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">how to write this expressions</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks</P><P style="font-size: 13.3333px;">Naveen</P></BODY></HTML> Mon, 24 Apr 2017 10:02:46 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306012#M460633 kunkumnaveen 2017-04-24T10:02:46Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306013#M460634 <HTML><HEAD></HEAD><BODY><P>Any suggestions how to write calculate dimension plz.....</P></BODY></HTML> Mon, 24 Apr 2017 10:17:51 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306013#M460634 kunkumnaveen 2017-04-24T10:17:51Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306014#M460635 <HTML><HEAD></HEAD><BODY><P>Hello Navin,</P><P></P><P>Trust that you are doing great!</P><P></P><P>Please refer attached sample application.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Mon, 24 Apr 2017 10:34:17 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306014#M460635 rahulpawarb 2017-04-24T10:34:17Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306015#M460636 <HTML><HEAD></HEAD><BODY><P>sorry i have personal addition ,i wont be able to open ur file ,will u please copy paste for me.....</P></BODY></HTML> Mon, 24 Apr 2017 10:37:19 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306015#M460636 kunkumnaveen 2017-04-24T10:37:19Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306016#M460637 <HTML><HEAD></HEAD><BODY><P>May be you can use this?</P><P></P><P><STRONG> (Sum({&lt;parts = {'=Count(parts)&gt;1'}&gt;}value)&nbsp; / Sum(TOTAL &lt;parts&gt; value))</STRONG></P></BODY></HTML> Mon, 24 Apr 2017 10:47:23 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306016#M460637 Anil_Babu_Samineni 2017-04-24T10:47:23Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306017#M460638 <HTML><HEAD></HEAD><BODY><P>Expression:</P><P>=if(count(distinct supplier)&gt;=2,part)</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160971_Untitled.png" style="height: auto;" /></P></BODY></HTML> Mon, 24 Apr 2017 10:48:33 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306017#M460638 kunkumnaveen 2017-04-24T10:48:33Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306018#M460639 <HTML><HEAD></HEAD><BODY><P>what about calculated dimension ,</P><P></P><P>i mean only to display part name which had more then one supplier</P><P>i tired this but no use</P><P></P><P>=if(count(distinct supplier)&gt;=2,part)</P></BODY></HTML> Mon, 24 Apr 2017 10:50:31 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306018#M460639 kunkumnaveen 2017-04-24T10:50:31Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306019#M460640 <HTML><HEAD></HEAD><BODY><P>Hello Navin,</P><P></P><P>Add supplier &amp; parts as dimension. Post that add below expressions:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14930311941727411 jive_text_macro" jivemacro_uid="_14930311941727411"> <P style="font-size: 13.3333px;">//value</P> <P style="font-size: 13.3333px;">If(Count(TOTAL &lt;parts&gt; supplier)&gt;1,Sum(value))</P> <P style="font-size: 13.3333px;"></P> <P style="font-size: 13.3333px;">//%of that supplier</P> <P style="font-size: 13.3333px;">If(Count(TOTAL &lt;parts&gt; supplier)&gt;1, Sum(value) / Sum(TOTAL &lt;parts&gt; value))</P> </PRE><P></P><P>Hope this will be helpful.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Mon, 24 Apr 2017 10:53:27 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306019#M460640 rahulpawarb 2017-04-24T10:53:27Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306020#M460641 <HTML><HEAD></HEAD><BODY><P>What are you expecting? I got like below</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160972_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 24 Apr 2017 10:54:58 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306020#M460641 Anil_Babu_Samineni 2017-04-24T10:54:58Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306021#M460642 <HTML><HEAD></HEAD><BODY><P>when&nbsp; i tried ur expression with sample data in qlikview i am getting perfect output,</P><P>but when i put same expression with my orginal data in qliksense i am not getting same output.</P><P>if u can help me more i can attach my qvf file if u send ur mail id , i cant share it on community . please</P></BODY></HTML> Mon, 24 Apr 2017 11:33:10 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306021#M460642 kunkumnaveen 2017-04-24T11:33:10Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306022#M460643 <HTML><HEAD></HEAD><BODY><P>Thank you for validating the same.</P><P></P><P><SPAN>My email address is&nbsp; - </SPAN><A class="jive-link-email-small" href="mailto:rahulpawarb@gmail.com">rahulpawarb@gmail.com</A></P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Mon, 24 Apr 2017 11:36:03 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306022#M460643 rahulpawarb 2017-04-24T11:36:03Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306023#M460644 <HTML><HEAD></HEAD><BODY><P>Rahul please check your mail</P></BODY></HTML> Mon, 24 Apr 2017 11:59:05 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306023#M460644 kunkumnaveen 2017-04-24T11:59:05Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306024#M460645 <HTML><HEAD></HEAD><BODY><P>Hello Rahul,</P><P>have u checked ur mail box ,have u gone through my qvf .....any clue bro</P></BODY></HTML> Mon, 24 Apr 2017 12:12:15 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306024#M460645 kunkumnaveen 2017-04-24T12:12:15Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306025#M460646 <HTML><HEAD></HEAD><BODY><P>Hello Naveen,</P><P></P><P>Extremely sorry brother. Yesterday I left office early. Please see my response on your email. <SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">Deselecting the </SPAN><STRONG style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">show zero values</STRONG><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"> option present under the Add-ons - Data handling section of table object will give you desired results.</SPAN></P><P></P><P>Please let me know if this is not expected response.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Tue, 25 Apr 2017 04:06:11 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306025#M460646 rahulpawarb 2017-04-25T04:06:11Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306026#M460647 <HTML><HEAD></HEAD><BODY><P>Hello Rahul,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Appreciated for your help bro.....</P></BODY></HTML> Tue, 25 Apr 2017 04:13:16 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306026#M460647 kunkumnaveen 2017-04-25T04:13:16Z Re: how to write expressions https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306027#M460648 <HTML><HEAD></HEAD><BODY><P>Cheers,</P><P>Rahul</P></BODY></HTML> Tue, 25 Apr 2017 04:28:53 GMT https://community.qlik.com/t5/QlikView/how-to-write-expressions/m-p/1306027#M460648 rahulpawarb 2017-04-25T04:28:53Z