topic Dimension If Statement in QlikView https://community.qlik.com/t5/QlikView/Dimension-If-Statement/m-p/1175970#M381705 <HTML><HEAD></HEAD><BODY><P>What is wrong with this statement? It says Expression OK.</P><P></P><P>I am trying to use it as one of 3 Dimensions but nothing is showing up when there should be...</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">RESP_PROG_DIR</SPAN><SPAN style="font-size: 8pt;">,'Not Classified')&gt;0 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TASK_STATUS</SPAN><SPAN style="font-size: 8pt;">,'Cancelled','Completed')&gt;0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">null</SPAN><SPAN style="font-size: 8pt;">(),</SPAN><SPAN style="color: #800000; font-size: 8pt;">RESP_PROG_DIR</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P></BODY></HTML> Wed, 22 Jun 2016 20:22:55 GMT cbaqir 2016-06-22T20:22:55Z Dimension If Statement https://community.qlik.com/t5/QlikView/Dimension-If-Statement/m-p/1175970#M381705 <HTML><HEAD></HEAD><BODY><P>What is wrong with this statement? It says Expression OK.</P><P></P><P>I am trying to use it as one of 3 Dimensions but nothing is showing up when there should be...</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">RESP_PROG_DIR</SPAN><SPAN style="font-size: 8pt;">,'Not Classified')&gt;0 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TASK_STATUS</SPAN><SPAN style="font-size: 8pt;">,'Cancelled','Completed')&gt;0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">null</SPAN><SPAN style="font-size: 8pt;">(),</SPAN><SPAN style="color: #800000; font-size: 8pt;">RESP_PROG_DIR</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P></BODY></HTML> Wed, 22 Jun 2016 20:22:55 GMT https://community.qlik.com/t5/QlikView/Dimension-If-Statement/m-p/1175970#M381705 cbaqir 2016-06-22T20:22:55Z Re: Dimension If Statement https://community.qlik.com/t5/QlikView/Dimension-If-Statement/m-p/1175971#M381706 <HTML><HEAD></HEAD><BODY><P>You expression looks fine for me, at least the syntax seems correct.</P><P></P><P>Maybe your condition is always true?</P></BODY></HTML> Wed, 22 Jun 2016 20:27:05 GMT https://community.qlik.com/t5/QlikView/Dimension-If-Statement/m-p/1175971#M381706 swuehl 2016-06-22T20:27:05Z