topic Re: set analysis syntax help in QlikView

set analysis syntax help

veeranj — Wed, 16 Apr 2014 11:57:44 GMT

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

Wed, 16 Apr 2014 11:59:13 GMT

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

regards

Darek

MK_QSL — Wed, 16 Apr 2014 12:01:24 GMT

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

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

veeranj — Wed, 16 Apr 2014 12:08:39 GMT

HI Manish,

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

rajat2392 — Wed, 16 Apr 2014 12:47:51 GMT

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

Wed, 16 Apr 2014 14:58:41 GMT

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