topic Re: Error message: Error in set modifier expression in QlikView

Error message: Error in set modifier expression

Mon, 03 Aug 2015 08:12:05 GMT

Hello All,

I created an expression for a variable but unfortunately it is not working:

Interval(Sum({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre/Count({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre)),'hh:mm:ss')

Error message: Error in set modifier expression

Any idea why?

Thanks

Re: Error message: Error in set modifier expression

qlikmsg4u — Mon, 03 Aug 2015 08:18:30 GMT

=Interval((Sum({<Date={">=$(=Date(Max(Date)))<=$(=Date(Max(Date)))"},{<NextState={'96'}>}DurationPre)/Count({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre)),'hh:mm:ss')

try this

You didn't closed the first set analysis expression

Re: Error message: Error in set modifier expression

Mon, 03 Aug 2015 08:20:57 GMT

No luck.same error message 😞

Re: Error message: Error in set modifier expression

qlikmsg4u — Mon, 03 Aug 2015 08:22:20 GMT

will you able to post the sample app?

Re: Error message: Error in set modifier expression

PrashantSangle — Mon, 03 Aug 2015 08:26:43 GMT

Hi,

Try

Interval(Sum({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},NextState={'96'}>}DurationPre) / Count({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},NextState={'96'}>}DurationPre)),'hh:mm:ss')

Regards

Re: Error message: Error in set modifier expression

qlikmsg4u — Mon, 03 Aug 2015 08:28:32 GMT

=Interval((Sum({<Date={">=$(=Date(Max(Date)))<=$(=Date(Max(Date)))"},NextState={'96'}>}DurationPre)/Count({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},NextState={'96'}>}DurationPre)),'hh:mm:ss')

Re: Error message: Error in set modifier expression

Mon, 03 Aug 2015 08:30:50 GMT

Hi Max,

It works fine now 🙂

Thanks,

Hasvine

Re: Error message: Error in set modifier expression

tresB — Mon, 03 Aug 2015 08:35:05 GMT

Couple of issues noticed highlighted in red.

Interval(Sum({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},{<NextState={96}>}DurationPre)/Count({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre)),'hh:mm:ss')

A date can't be '>=' and '<=' of a date (you used max(date)), It should ideally be some earlier date for '>=' comparison. May be like:

Addmonths(Max(Date),-1). You could share your sample qvw to get it corrected.