topic Re: set analysis with dates in QlikView

set analysis with dates

karolina_ — Fri, 11 Aug 2017 09:56:50 GMT

Hi All

I cannot make set analysis work with fields - StartMonth and EndMonth as in attachement.

I tried it with as StartMonth, date( StartMonth,'YYYY-MM-DD'), $(=date( StartMonth,'YYYY-MM-DD')) nothing works

srishsum2017 — Fri, 11 Aug 2017 10:05:49 GMT

Hi, Please use single quotes at the place of double quotes

vardhancse — Fri, 11 Aug 2017 10:13:01 GMT

Hi Change the expression to

=count({<[Hire date]={"$(='>=' & StartMotnh & '<=' & EndMonth)"}>}DISTINCT ID)

tresB — Fri, 11 Aug 2017 10:16:42 GMT

Try like:

Count(DISTINCT if([Hire date]>=StartMotnh and [Hire date]<=EndMonth, ID))

antoniotiman — Fri, 11 Aug 2017 10:21:30 GMT

Hi Karolina,

You can't use Set Analysis.

Set Analysis is evaluated per Chart, not per Rows.

So, use like this

Count(DISTINCT If([Hire date] >= StartMotnh and [Hire date] <= EndMonth, ID))

Regards,

Antonio