topic month start in set analysis in QlikView

month start in set analysis

samuel_brierley — Mon, 10 Aug 2015 15:51:27 GMT

Hi all,

can someone please explain why the first formula results in the error 'Error in set modifier'

and please point me to how to correct it.

thanks in advance

=count({1<Issue_Date = {$(=MonthStart(Now()))} ,Fault_Classification = {'3'} >}Fault_Classification)

=count({1<Issue_Date = {'01/08/2015'} ,Fault_Classification = {'3'} >}Fault_Classification)

sunny_talwar — Mon, 10 Aug 2015 15:55:13 GMT

May be try it with double quotes:

=Count({1<Issue_Date = {"$(=MonthStart(Now()))"}, Fault_Classification = {'3'} >} Fault_Classification) or

=Count({1<Issue_Date = {"$(=Date(MonthStart(Now()), 'DD/MM/YYYY'))"}, Fault_Classification = {'3'} >} Fault_Classification)

samuel_brierley — Mon, 10 Aug 2015 15:57:04 GMT

Yep That's got it thanks