topic Please covert the expression from if to set in QlikView

topic Please covert the expression from if to set in QlikView https://community.qlik.com/t5/QlikView/Please-covert-the-expression-from-if-to-set/m-p/668287#M242978 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I wrote below expression by using 'If', can any body tell me same condition how i can use with 'Set'.</P><P></P><P>=If(DATE(Today(),'MMM-YYYY')>Month_Year,sum(Revenue1<SPAN style="font-size: 10pt; line-height: 1.5em;">),sum(Revenue2))</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 10 Sep 2014 12:36:41 GMT 2014-09-10T12:36:41Z Please covert the expression from if to set https://community.qlik.com/t5/QlikView/Please-covert-the-expression-from-if-to-set/m-p/668287#M242978 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I wrote below expression by using 'If', can any body tell me same condition how i can use with 'Set'.</P><P></P><P>=If(DATE(Today(),'MMM-YYYY')>Month_Year,sum(Revenue1<SPAN style="font-size: 10pt; line-height: 1.5em;">),sum(Revenue2))</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 10 Sep 2014 12:36:41 GMT https://community.qlik.com/t5/QlikView/Please-covert-the-expression-from-if-to-set/m-p/668287#M242978 2014-09-10T12:36:41Z