topic Re: Set Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Expression/m-p/623853#M229584 <HTML><HEAD></HEAD><BODY><P>sum( {1&lt;[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]-={"$(=Only([TO-MONTH]))"},TYPE={'F'}&gt;} [PREMIUM] )</P></BODY></HTML> Sat, 08 Feb 2014 09:56:03 GMT 2014-02-08T09:56:03Z Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/623852#M229583 <HTML><HEAD></HEAD><BODY><P>I have created the following set expression and it is working fine.</P><P></P><P>sum( {1&lt;[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]={"$(=Only([R_MONTH]))"}&gt;} [PREMIUM] )</P><P></P><P>I have two other&nbsp; dimensions in my chart 'TO_MONTH' and 'TYPE' I want to modify the above expression to extract data where I want fulfill following conditions</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp; R_YEAR] = {"$(=Only([R_YEAR]))"</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; [R_MONTH] not equal to TO-MONTH</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; TYPE='F'</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Pls help me to rewrite the Set expression&nbsp; </SPAN></P></BODY></HTML> Sat, 08 Feb 2014 09:36:39 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/623852#M229583 upaliwije 2014-02-08T09:36:39Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/623853#M229584 <HTML><HEAD></HEAD><BODY><P>sum( {1&lt;[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]-={"$(=Only([TO-MONTH]))"},TYPE={'F'}&gt;} [PREMIUM] )</P></BODY></HTML> Sat, 08 Feb 2014 09:56:03 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/623853#M229584 2014-02-08T09:56:03Z