where in Edit Expression Dialog

[#1]

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

[Nicole-Smith]

Try:

count({<Rule={'*Rule A*'}>}Question)

If you only want each Question counted once:

count({<Rule={'*Rule A*'}>}distinct Question)