topic Re: syntax expression in QlikView https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201938#M880872 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P><STRONG><SPAN lang="SV" style="color: black; font-family: 'Arial','sans-serif';">SUM( </SPAN><SPAN lang="SV" style="color: red; font-family: 'Arial','sans-serif';">{</SPAN><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';">&lt;RecordType= {'Members'}, </SPAN></STRONG><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';"><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';"><STRONG>DataType= {'Current'}</STRONG></SPAN></SPAN><STRONG><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';"><STRONG> &gt;</STRONG></SPAN><SPAN lang="SV" style="color: red; font-family: 'Arial','sans-serif';">}</SPAN><SPAN lang="SV" style="color: black; font-family: 'Arial','sans-serif';"> Values )</SPAN></STRONG> </P><P></P><P>- Marcus</P></BODY></HTML> Wed, 05 Oct 2016 07:13:20 GMT marcus_sommer 2016-10-05T07:13:20Z syntax expression https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201936#M880870 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to state:-</P><P></P><P>if the RecordType = 'Members' and the DataType = ' Current' , sum the Values.&nbsp; How do I add the second half to syntax please:-</P><P><SPAN style="font-size: 8pt;">I have found other examples but not this one .</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P style="margin: 10pt 0px 0px;"><STRONG><SPAN lang="SV" style="color: black; line-height: 115%; font-family: 'Arial','sans-serif'; mso-bidi-font-size: 11.0pt;">SUM( </SPAN><SPAN lang="SV" style="color: red; line-height: 115%; font-family: 'Arial','sans-serif'; mso-bidi-font-size: 11.0pt;">{</SPAN><SPAN lang="SV" style="color: #00b050; line-height: 115%; font-family: 'Arial','sans-serif'; mso-bidi-font-size: 11.0pt;">&lt;RecordType= {"Members"} &gt;</SPAN><SPAN lang="SV" style="color: red; line-height: 115%; font-family: 'Arial','sans-serif'; mso-bidi-font-size: 11.0pt;">}</SPAN><SPAN lang="SV" style="color: black; line-height: 115%; font-family: 'Arial','sans-serif'; mso-bidi-font-size: 11.0pt;"> Values )</SPAN></STRONG> </P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Cheers,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Laura</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201936#M880870 Anonymous 2020-11-25T16:16:04Z Re: syntax expression https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201937#M880871 <HTML><HEAD></HEAD><BODY><P>Like this:</P><P>SUM( {&lt;RecordType= {'Members'} <STRONG>,</STRONG> <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>DataType = {'Current'}</STRONG> </SPAN> &gt;} Values )</P></BODY></HTML> Wed, 05 Oct 2016 07:11:15 GMT https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201937#M880871 tresB 2016-10-05T07:11:15Z Re: syntax expression https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201938#M880872 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P><STRONG><SPAN lang="SV" style="color: black; font-family: 'Arial','sans-serif';">SUM( </SPAN><SPAN lang="SV" style="color: red; font-family: 'Arial','sans-serif';">{</SPAN><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';">&lt;RecordType= {'Members'}, </SPAN></STRONG><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';"><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';"><STRONG>DataType= {'Current'}</STRONG></SPAN></SPAN><STRONG><SPAN lang="SV" style="color: #00b050; font-family: 'Arial','sans-serif';"><STRONG> &gt;</STRONG></SPAN><SPAN lang="SV" style="color: red; font-family: 'Arial','sans-serif';">}</SPAN><SPAN lang="SV" style="color: black; font-family: 'Arial','sans-serif';"> Values )</SPAN></STRONG> </P><P></P><P>- Marcus</P></BODY></HTML> Wed, 05 Oct 2016 07:13:20 GMT https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201938#M880872 marcus_sommer 2016-10-05T07:13:20Z Re: syntax expression https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201939#M880873 <HTML><HEAD></HEAD><BODY><P>Sometimes the color alone can win you points. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P></BODY></HTML> Wed, 05 Oct 2016 07:21:21 GMT https://community.qlik.com/t5/QlikView/syntax-expression/m-p/1201939#M880873 tresB 2016-10-05T07:21:21Z