topic Re: Question on Simple set analysis. in QlikView

Question on Simple set analysis.

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

The result is not coming for below set analysis.

count({<[Date error/issue discovered]={">=$(MonthStart(max([Date error/issue discovered]) <=(today())"} >}[Type of error/issue])

Re: Question on Simple set analysis.

sunny_talwar — Thu, 21 Jul 2016 16:19:50 GMT

Try this:

Count({<[Date error/issue discovered]={">=$(=Date(MonthStart(Max([Date error/issue discovered])), 'DateFieldFormatHere')<=$(=Date(Today(), 'DateFieldFormatHere'))"} >}[Type of error/issue])

Re: Question on Simple set analysis.

subathra — Mon, 22 Aug 2016 07:18:51 GMT

count({<[Date error/issue discovered]={'>=$(=MonthStart(max([Date error/issue discovered]))) <=$(=(today()))'} >}

[Type of error/issue])

Re: Question on Simple set analysis.

crusader_ — Mon, 22 Aug 2016 12:07:15 GMT

Hi,

First of all check Date format of [Date error/issue discovered] field and then turn everything to single view like stalwar1‌ mentioned previously or turn everything to numbers:

Count({<[Date error/issue discovered]={">=$(=Floor(MonthStart(Max([Date error/issue discovered]))))<=$(=Floor(Today()))"} >}[Type of error/issue])

Hope this helps.

Regards,

Andrei