Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
veeranj
Creator II
Creator II

set analysis syntax help

HI Group,

I need the syntax in writing set analysis expresion.

i have columns like emp_disengaged_date,reason,id

i want to count the no of employees whose date is greater than today and with employees with reason c (whose date<todays date)

thanks,

Anjee

5 Replies
Not applicable

It will be better if you may share qvd with your data model and sample data.

regards

Darek

MK_QSL
MVP
MVP

COUNT({<reason = {'c'}, emp_disengaged_date = {'>$(=Date(Today()))'} >}employees)

or

COUNT({<reason = {'c'}, emp_disengaged_date = {'>$(=Date(Today()))'} >}Distinct employees)

veeranj
Creator II
Creator II
Author

HI Manish,

Here the reason =c and emp_disengaged_date = {'>$(=Date(Today())) are and conditions ?

rajat2392
Partner - Creator III
Partner - Creator III

yes..this will work as AND condition..if both are true, then the count is made.

Not applicable

COUNT({<reason = {'c'}, emp_disengaged_date = {'>$(=Date(Today()))'} >}id)


it will count the number of  id's,

based on the conditions Reason = 'c' and date > today