How to filter multiple conditions in an expression

[FilipB]

Hi,

I’m relatively new to qlik sense.

I want to have a count of number of jobs that match multiple conditions.

My sql-query looks like

select * from dba.Job

where JobRecStatus in ('16','32','4096') and JobReportDate>'2020-08-31 00:00:00.0000000 +02:00'

How can I reproduce this in a qlik sense expression?

Grts,
Filip

[ogster1974]

Something like

count(distinct {<JobRecStatus ={'16','32','4096'}, JobReportDate={"=JobReportDate>'2020-08-31 00:00:00.0000000 +02:00'"}>} jobId)

[FilipB]

Hi Ogster

I receive an error in expression when I use your solution...