1 Reply Latest reply: Feb 13, 2014 8:25 AM by Nicole Smith RSS

    where in Edit Expression Dialog

      Hi Guys,

       

      I want to make in Edit Expression dialog  where condition like sql query

      select Question from company1 where rule='.RuleA'     

      When I tried to calculate on the top of qlikview edit expression dialog as condition shown below:

      if((mid(concat({<Rule = P(Rule)>}distinct Rule, ','),1,7))='·Rule A',count(Question),0)

      It gives me wrong result , because the count of questions is general not related to me if condition

       

      The question how can I build condition like sql previous query ?

       

       

      Regards,

      Ayham