Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Re: set analysis syntax help

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

regards

Darek

Highlighted
MVP
MVP

Re: set analysis syntax help

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

or

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

Highlighted
Creator II
Creator II

Re: set analysis syntax help

HI Manish,

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

Highlighted
Partner
Partner

Re: set analysis syntax help

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

Highlighted
Not applicable

Re: set analysis syntax help

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