where in Edit Expression Dialog

Thu, 13 Feb 2014 12:18:27 GMT

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

Re: where in Edit Expression Dialog

Nicole-Smith — Thu, 13 Feb 2014 13:25:34 GMT

Try:

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

If you only want each Question counted once:

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