topic Re: Multiple conditions in expression in QlikView https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316408#M408663 <HTML><HEAD></HEAD><BODY><P>Use this</P><P></P><P><STRONG>Count({&lt;FOLDERTYPE = {'$(=WildMatch(FolderType,'*RC*'))'}&gt;} FOLDERRSN)</STRONG></P></BODY></HTML> Fri, 14 Apr 2017 01:56:11 GMT Anil_Babu_Samineni 2017-04-14T01:56:11Z Multiple conditions in expression https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316406#M408661 <HTML><HEAD></HEAD><BODY><P>In a text object, I am trying to display a distinct number of folders of a certain type.</P><P>in SQL it would be written as</P><P>SELECT DISTINCT (COUNT(FOLDERRSN)),</P><P>FOLDERTYPE</P><P>FROM folder f</P><P>WHERE f.foldertype = 'RC'.</P><P></P><P>What I have entered as expression is</P><P>Num((Sum(FOLDERTYPE='RC')*-1),'#,##0', ',') </P><P></P><P>Some of these records repeat a few times which is fine as there are multiple inspections done - as shown in the attachment</P><P><SPAN style="font-size: 10pt;">I want to count each folderrsn once even if it has multiple inspections.</SPAN></P><P></P><P>NOTE - Folderrsn is a unique key, RC is foldertype, and Inspection is the type of inspection it went through.</P></BODY></HTML> Thu, 13 Apr 2017 19:10:30 GMT https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316406#M408661 2017-04-13T19:10:30Z Re: Multiple conditions in expression https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316407#M408662 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">FOLDERTYPE</SPAN><SPAN style="font-size: 8pt;">='RC'&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> FOLDERRSN</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Thu, 13 Apr 2017 20:28:40 GMT https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316407#M408662 craigsutton 2017-04-13T20:28:40Z Re: Multiple conditions in expression https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316408#M408663 <HTML><HEAD></HEAD><BODY><P>Use this</P><P></P><P><STRONG>Count({&lt;FOLDERTYPE = {'$(=WildMatch(FolderType,'*RC*'))'}&gt;} FOLDERRSN)</STRONG></P></BODY></HTML> Fri, 14 Apr 2017 01:56:11 GMT https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316408#M408663 Anil_Babu_Samineni 2017-04-14T01:56:11Z Re: Multiple conditions in expression https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316409#M408664 <HTML><HEAD></HEAD><BODY><P>It is not recognizing DISTINCT as a key word.</P></BODY></HTML> Tue, 18 Apr 2017 12:19:28 GMT https://community.qlik.com/t5/QlikView/Multiple-conditions-in-expression/m-p/1316409#M408664 2017-04-18T12:19:28Z