2 Replies Latest reply: Jun 25, 2012 7:06 AM by Gerard Carvalho RSS

    Conditional expression issue

      Hi All,

      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  For example jan =SubStringCount(GetFieldSelections(Month,',',100),'Jan')>0 and GetFieldSelections(Quarter) <> 'Q2'

      and GetFieldSelections(Quarter) <> 'Q3' and GetFieldSelections(Quarter) <> 'Q4'

       

      pic1.png

       

      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 combination.

       

      pic2.png

      Kindly provide a solution.

       

      Regards,

      Gerard