topic Re: how to write expression in QlikView https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359975#M460449 <HTML><HEAD></HEAD><BODY><P>is equivalent to</P><P><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">({&lt;<SPAN style="color: #800000;">product</SPAN>={seat,'glass','break'}&gt;}<SPAN style="color: #800000;">supplier</SPAN></SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">However the list is hardcoded.</SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Wed, 17 May 2017 10:00:17 GMT antoniotiman 2017-05-17T10:00:17Z how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359971#M460445 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>i want to count product which is supplied by only one supplier..</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">supplier&nbsp;&nbsp;&nbsp; product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gear</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gear</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; glass</P><P>E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; seat</P><P></P><P>Answer : 3 because break,glass, seat is supplied by only one supplier</P><P></P><P>how to write expression ?&nbsp;&nbsp; plz</P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 May 2017 08:41:29 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359971#M460445 kunkumnaveen 2017-05-17T08:41:29Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359972#M460446 <HTML><HEAD></HEAD><BODY><P>Try in text box</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN> <SPAN style="color: #800000;">supplier</SPAN>) = 1,<SPAN style="color: #800000;">supplier</SPAN>),<SPAN style="color: #800000;">product</SPAN></SPAN><SPAN style="font-size: 10pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Wed, 17 May 2017 08:51:39 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359972#M460446 antoniotiman 2017-05-17T08:51:39Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359973#M460447 <HTML><HEAD></HEAD><BODY><P>As expression:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">product</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=count(supplier)=1"</SPAN><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">supplier</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Wed, 17 May 2017 08:57:26 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359973#M460447 sergio0592 2017-05-17T08:57:26Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359974#M460448 <HTML><HEAD></HEAD><BODY><P>May be</P><P></P><P>=count({&lt;product=P({&lt;product={seat,'glass','break'}&gt;})&gt;}supplier)</P></BODY></HTML> Wed, 17 May 2017 09:19:03 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359974#M460448 qlikview979 2017-05-17T09:19:03Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359975#M460449 <HTML><HEAD></HEAD><BODY><P>is equivalent to</P><P><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">({&lt;<SPAN style="color: #800000;">product</SPAN>={seat,'glass','break'}&gt;}<SPAN style="color: #800000;">supplier</SPAN></SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">However the list is hardcoded.</SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Wed, 17 May 2017 10:00:17 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1359975#M460449 antoniotiman 2017-05-17T10:00:17Z