topic Re: Conditional expression issue in QlikView https://community.qlik.com/t5/QlikView/Conditional-expression-issue/m-p/365758#M136070 <HTML><HEAD></HEAD><BODY><P>Gerard,</P><P></P><P>I just posted a suggested solution to your other post. Please try not to duplicate threads, this makes it hard to follow a discussion.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Mon, 25 Jun 2012 09:06:02 GMT swuehl 2012-06-25T09:06:02Z Conditional expression issue https://community.qlik.com/t5/QlikView/Conditional-expression-issue/m-p/365757#M136069 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P style="margin-bottom: .0001pt;">In my qv application I have created a straight table as the attached sample. The conditional expression that I have used for individual month field is&nbsp; For example jan <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=SubStringCount(GetFieldSelections(Month,',',100),'Jan')&gt;0 and GetFieldSelections(Quarter) &lt;&gt; 'Q2'</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">and GetFieldSelections(Quarter) &lt;&gt; 'Q3' and GetFieldSelections(Quarter) &lt;&gt; 'Q4' </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><IMG __jive_id="16931" class="jive-image-thumbnail jive-image" onclick="" alt="pic1.png" src="https://community.qlik.com/legacyfs/online/16931_pic1.png" width="450" /><BR /></SPAN></P><P></P><P>But when I select any combination of quarter like Q2 and Q3, the output is like All the months are displayed with Q1 and Q4 months with 0 and Q2 , Q3 months with data. The output is correct but I don’t want Q1, Q4 to be displayed, since we are selecting only Q2 and Q3. This is for all possible Quarter </P><P>combination.</P><P></P><P><IMG __jive_id="16932" class="jive-image-thumbnail jive-image" onclick="" alt="pic2.png" src="https://community.qlik.com/legacyfs/online/16932_pic2.png" width="450" /></P><P>Kindly provide a solution.</P><P></P><P>Regards,</P><P>Gerard</P></BODY></HTML> Mon, 25 Jun 2012 06:12:25 GMT https://community.qlik.com/t5/QlikView/Conditional-expression-issue/m-p/365757#M136069 2012-06-25T06:12:25Z Re: Conditional expression issue https://community.qlik.com/t5/QlikView/Conditional-expression-issue/m-p/365758#M136070 <HTML><HEAD></HEAD><BODY><P>Gerard,</P><P></P><P>I just posted a suggested solution to your other post. Please try not to duplicate threads, this makes it hard to follow a discussion.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Mon, 25 Jun 2012 09:06:02 GMT https://community.qlik.com/t5/QlikView/Conditional-expression-issue/m-p/365758#M136070 swuehl 2012-06-25T09:06:02Z