topic Re: Set analysis as well as matching text/numbers in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-as-well-as-matching-text-numbers/m-p/405801#M490870 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Easier than it seems!</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1349971653646902" jivemacro_uid="_1349971653646902"><P>Sum({&lt; [Date] = {"&gt;=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))&lt;=$(=max(Date))"}, [Immediate Cause] = {"12*"} &gt;} [Accidents Count ID])</P></PRE><P></P><P>That will check for all values starting by "12"</P><P></P><P>Hope that helps,</P><P></P><P>Miguel</P></BODY></HTML> Thu, 11 Oct 2012 16:08:11 GMT Miguel_Angel_Baeyens 2012-10-11T16:08:11Z Set analysis as well as matching text/numbers https://community.qlik.com/t5/QlikView/Set-analysis-as-well-as-matching-text-numbers/m-p/405800#M490869 <HTML><HEAD></HEAD><BODY><P>I have a set analysis expression </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>sum</P><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))&lt;=$(=max(Date))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Accidents Count ID]</SPAN><SPAN style="font-size: 8pt;">) </SPAN><P></P><P></P><P></P><P></P><P></P><P>The above is working fine but I wish to further filter the analysis by only having the above for records where a field 'Immediate Cause' is populated by a number of values such as '12i', '12j','12k' etc etc. I have tried adapting the like/match commands but cannot combine those with the set analysis expression above</P><P></P><P>Any ideas please?</P></BODY></HTML> Thu, 11 Oct 2012 16:04:15 GMT https://community.qlik.com/t5/QlikView/Set-analysis-as-well-as-matching-text-numbers/m-p/405800#M490869 2012-10-11T16:04:15Z Re: Set analysis as well as matching text/numbers https://community.qlik.com/t5/QlikView/Set-analysis-as-well-as-matching-text-numbers/m-p/405801#M490870 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Easier than it seems!</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1349971653646902" jivemacro_uid="_1349971653646902"><P>Sum({&lt; [Date] = {"&gt;=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))&lt;=$(=max(Date))"}, [Immediate Cause] = {"12*"} &gt;} [Accidents Count ID])</P></PRE><P></P><P>That will check for all values starting by "12"</P><P></P><P>Hope that helps,</P><P></P><P>Miguel</P></BODY></HTML> Thu, 11 Oct 2012 16:08:11 GMT https://community.qlik.com/t5/QlikView/Set-analysis-as-well-as-matching-text-numbers/m-p/405801#M490870 Miguel_Angel_Baeyens 2012-10-11T16:08:11Z