topic Help with expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/219091#M72137 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the following expression in a pivot.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=IF((sum(if(Month([Date1])='Feb',1,0)) * sum(if(Month([Date2])='Feb',1,0))),<BR /> sum(if(Month([Date2])='Feb',1,0)))</PRE><BR /><BR /> <P>This basically does is aggregates for the dimension product and counts the number of entries for the product where Date2 has a value.</P><P>Is there a way to write this expression to be free from the current selections like we can do in set analysis and which may be better on performance, may be using Set Analysis?</P><P>Any suggestions.</P><P>Thanks.</P></BODY></HTML> Tue, 20 Apr 2010 14:08:13 GMT amit_shetty78 2010-04-20T14:08:13Z Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/219091#M72137 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the following expression in a pivot.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=IF((sum(if(Month([Date1])='Feb',1,0)) * sum(if(Month([Date2])='Feb',1,0))),<BR /> sum(if(Month([Date2])='Feb',1,0)))</PRE><BR /><BR /> <P>This basically does is aggregates for the dimension product and counts the number of entries for the product where Date2 has a value.</P><P>Is there a way to write this expression to be free from the current selections like we can do in set analysis and which may be better on performance, may be using Set Analysis?</P><P>Any suggestions.</P><P>Thanks.</P></BODY></HTML> Tue, 20 Apr 2010 14:08:13 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/219091#M72137 amit_shetty78 2010-04-20T14:08:13Z