topic Re: Between in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309789#M833936 <HTML><HEAD></HEAD><BODY><P>you can also use set analysis builder based on our requirement</P><P></P><P><A href="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=" title="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=">Set Analysis Wizard for QlikView | qlikblog.at</A></P></BODY></HTML> Mon, 05 Jun 2017 08:54:52 GMT tajmohamed30 2017-06-05T08:54:52Z Between in Set Analysis https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309787#M833934 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P>Please Suggest me how to use this below condition inside a set analysis </P><P>Below is the SQL Condition</P><P>where </P><P>(left(Productcode, 3) BETWEEN 'C00' AND 'D99')</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309787#M833934 rajkumarb 2020-11-25T16:16:04Z Re: Between in Set Analysis https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309788#M833935 <HTML><HEAD></HEAD><BODY><P>Hi Raj,</P><P>try</P><P><SPAN style="color: #0000ff; font-size: 10pt;">Sum</SPAN><SPAN style="font-size: 10pt;">({&lt;<SPAN style="color: #800000;">Product</SPAN>={<SPAN style="color: #800000;">"=Left(Product,3) &gt;= 'C00' and Left(Product,3) &lt;= 'D99'"</SPAN>}&gt;} <SPAN style="color: #800000;">Value</SPAN>) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Mon, 05 Jun 2017 08:43:59 GMT https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309788#M833935 antoniotiman 2017-06-05T08:43:59Z Re: Between in Set Analysis https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309789#M833936 <HTML><HEAD></HEAD><BODY><P>you can also use set analysis builder based on our requirement</P><P></P><P><A href="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=" title="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=">Set Analysis Wizard for QlikView | qlikblog.at</A></P></BODY></HTML> Mon, 05 Jun 2017 08:54:52 GMT https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309789#M833936 tajmohamed30 2017-06-05T08:54:52Z Re: Between in Set Analysis https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309790#M833937 <HTML><HEAD></HEAD><BODY><P>yes, that will work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Mon, 05 Jun 2017 09:09:27 GMT https://community.qlik.com/t5/QlikView/Between-in-Set-Analysis/m-p/1309790#M833937 Anonymous 2017-06-05T09:09:27Z