topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809667#M536244 <HTML><HEAD></HEAD><BODY><P>Hi Dear,&nbsp; </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:09:25 GMT 2014-11-24T17:09:25Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809667#M536244 <HTML><HEAD></HEAD><BODY><P>Hi Dear,&nbsp; </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:09:25 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/809667#M536244 2014-11-24T17:09:25Z