Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Expression with WHERE and OR clause

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)

1 Solution

Accepted Solutions

Re: Expression with WHERE and OR clause

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


talk is cheap, supply exceeds demand
1 Reply

Re: Expression with WHERE and OR clause

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


talk is cheap, supply exceeds demand
Community Browser