topic Re: Set analysis in QlikView

Set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Can someone please assist me on below issue.

Coding: in below code first condition only working (ex. Issue = Internal privacy incident only working, another condition Month conditions is not working)

count({< Issue = {'Internal Privacy incident'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))<=$(=MonthEnd(Max(Month))) >} Issue)

Re: Set analysis

effinty2112 — Sat, 03 Sep 2016 12:39:09 GMT

Hi Ravi,

Loks like you've omitted a ".

Try this :

count({< Issue = {'Internal Privacy incident'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))=$(=MonthEnd(Max(Month)))" >} Issue)

Cheers

Andrew

Re: Set analysis

Anil_Babu_Samineni — Sat, 03 Sep 2016 12:50:40 GMT

count({< Issue = {'[Internal Privacy incident]'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))<=$(=MonthEnd(Max(Month))) >} Issue)

Re: Set analysis

antoniotiman — Sat, 03 Sep 2016 13:38:27 GMT

Hi Ravi,

I assume Month is Dual Field

Try

count({< Issue = {'Internal Privacy incident'}, Month={'>=$(=Max(Month)-3)'}>} Issue)

Regards,

Antonio

Re: Set analysis

swuehl — Sat, 03 Sep 2016 13:41:24 GMT

Also have a look at

Dates in Set Analysis

If you still have problems with your set modifier, please post the exact format specifier of your Month field.