topic Re: Error in set modifier expression in QlikView

Solved: Error in set modifier expression

Jennyy — Mon, 15 Jul 2024 11:18:19 GMT

Hi,

Can someone help me with the 'error in set modifier expression' in this code?:

I want to calculate the sales of last month

Sum({< Year, [Quarter], [Month], week, Day,

[Date] = {"$(= '>=' & MonthStart(AddMonths(Max([Date]),-1)) & '<=' & AddMonths(Max([Date]),-1))"},

$<[Product group]={'Fruit'}>
-1<[Article name]={'apple'}
>}

sales)

Re: Error in set modifier expression

theoat — Fri, 12 Jul 2024 12:23:18 GMT

Hello,

You can try something like this :

Sum({
< Year,
[Quater],
[Month],
week,
Day,
[Date] = {">=$(=MonthStart(AddMonths(Max([Date]),-1)))<=$(=MonthEnd(AddMonths(Max([Date]),-1)))"},
[Product group] = {'Fruit'},
[Article name] -= {'apple'}
>} 
sales)

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: Error in set modifier expression

Jennyy — Fri, 12 Jul 2024 12:34:11 GMT

Thanks Théo, but it still has the same error. Is there another solution? Best, Jen

Re: Error in set modifier expression

theoat — Fri, 12 Jul 2024 12:35:45 GMT

Can you share me an set of data to make tests?

Re: Error in set modifier expression

Jennyy — Fri, 12 Jul 2024 13:21:45 GMT

Sorry I can't, because of privacy issues...

Re: Error in set modifier expression

marcus_sommer — Fri, 12 Jul 2024 14:34:13 GMT

Just check it step by step and commenting all conditions unless one and the next and the next ...

Beside this the suggestion from Theo should work from a syntax point of view (if all field-names were correct specified) because it's a single set statement with n conditions while your approach was n set statements which weren't correct opened/closed and linked.