topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809972#M1043370 <HTML><HEAD></HEAD><BODY><P><BR />Hi Dear,</P><P></P><P>A novice in QlikView can anyone please help me with troubleshooting this formula. Not sure whether I got the syntax right. The objective here is to first off check if the QtrMonthValue is empty then colour it white, else apply the RAG status of Green or Red depending on whether the QtrMonthValue is gretaer or less than the IndThreshold value.</P><P>=<SPAN style="color: #0000ff;">if </SPAN>(<SPAN style="color: #0000ff;">only </SPAN>({1&lt;<SPAN style="color: #800000;">QuarterNo </SPAN>= {'3'}&gt;} <SPAN style="color: #800000;">QtrMonthValue</SPAN>)= <SPAN style="color: #0000ff;">Null </SPAN>(),<STRONG><EM style="color: #808080;">White()</EM></STRONG>, <SPAN style="color: #0000ff;">if </SPAN>(<SPAN style="color: #0000ff;">max</SPAN>({1&lt;<SPAN style="color: #800000;">QuarterYear </SPAN>={'$(='Qtr3-'&amp;only(Year_Fiscal))'}&gt;} QtrMonthValue)) &gt;= num(IndThreshold,'#,##0.0%'),vRAGGreen1,vRAGRed1)<STRONG style="color: #ff0000;"> .</STRONG></P><P></P><P><STRONG style="color: #ff0000;">Any help will be most appreciated!</STRONG></P></BODY></HTML> Mon, 24 Nov 2014 17:47:12 GMT 2014-11-24T17:47:12Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809972#M1043370 <HTML><HEAD></HEAD><BODY><P><BR />Hi Dear,</P><P></P><P>A novice in QlikView can anyone please help me with troubleshooting this formula. Not sure whether I got the syntax right. The objective here is to first off check if the QtrMonthValue is empty then colour it white, else apply the RAG status of Green or Red depending on whether the QtrMonthValue is gretaer or less than the IndThreshold value.</P><P>=<SPAN style="color: #0000ff;">if </SPAN>(<SPAN style="color: #0000ff;">only </SPAN>({1&lt;<SPAN style="color: #800000;">QuarterNo </SPAN>= {'3'}&gt;} <SPAN style="color: #800000;">QtrMonthValue</SPAN>)= <SPAN style="color: #0000ff;">Null </SPAN>(),<STRONG><EM style="color: #808080;">White()</EM></STRONG>, <SPAN style="color: #0000ff;">if </SPAN>(<SPAN style="color: #0000ff;">max</SPAN>({1&lt;<SPAN style="color: #800000;">QuarterYear </SPAN>={'$(='Qtr3-'&amp;only(Year_Fiscal))'}&gt;} QtrMonthValue)) &gt;= num(IndThreshold,'#,##0.0%'),vRAGGreen1,vRAGRed1)<STRONG style="color: #ff0000;"> .</STRONG></P><P></P><P><STRONG style="color: #ff0000;">Any help will be most appreciated!</STRONG></P></BODY></HTML> Mon, 24 Nov 2014 17:47:12 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809972#M1043370 2014-11-24T17:47:12Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809973#M1043371 <HTML><HEAD></HEAD><BODY><P>Hi Alhasan,</P><P></P><P>Are you getting desired outcome.</P><P>Can you upload the data please,so can try to help.</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Mon, 24 Nov 2014 19:08:55 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809973#M1043371 Anonymous 2014-11-24T19:08:55Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809974#M1043373 <HTML><HEAD></HEAD><BODY><P>Try using the colormix wizard.</P><P></P><P>File menu in the expression editor.&nbsp; You can enter the modifiers there. </P><P></P><P>Not sure if this takes up more or less CPU resource.</P></BODY></HTML> Mon, 24 Nov 2014 20:24:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809974#M1043373 2014-11-24T20:24:43Z