Expression with WHERE and OR clause

Tue, 30 Jul 2013 18:27:43 GMT

I am trying to create a chart with an expression where it does a count on OwnerID with a Where and OR clause.

For example, i want to do a count where the [Working Status] = 'Employee' or 'Consultant'. If I do not use the WHERE clause then the chart returns all values for Working Status (i.e. Consultant, Employee, Intern, Client, etc...)

I tried using the following line of code, but it displays Consultant only.

=count ({<[Working Status] = {'Employee'},[Working Status] = {'Consultant'}>} Distinct OwnerID)

Re: Expression with WHERE and OR clause

Gysbert_Wassenaar — Tue, 30 Jul 2013 18:30:12 GMT

Try: =count ({<[Working Status] = {'Employee','Consultant'}>} Distinct OwnerID)

topic Re: Expression with WHERE and OR clause in QlikView

Expression with WHERE and OR clause

Re: Expression with WHERE and OR clause