Error message: Error in set modifier expression

[#1]

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

[qlikmsg4u]

=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

[#3]

No luck.same error message 😞

[qlikmsg4u]

will you able to post the sample app?

[PrashantSangle · Accepted solution]

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

[qlikmsg4u]

=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')

[#7]

Hi Max,

It works fine now 🙂

Thanks,

Hasvine

[tresesco]

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.