Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like
count(distinct {<JobRecStatus ={'16','32','4096'}, JobReportDate={"=JobReportDate>'2020-08-31 00:00:00.0000000 +02:00'"}>} jobId)
Hi Ogster
I receive an error in expression when I use your solution...