Group diferent conditions in the same set analysis

[#1]

Hi, i want to include two diferent condition in a same set analysis, and i cant figure out how:

  The conditions are:

         All the sales in a given day, lets say monday; in all categoryes but 2, lets say 11 and 12.

So im trying something like this

     Sum({$<Day={"Monday"},Category_ID <> {"11","12"} >}Sales)

it dont work.

Thanks in advance.

[swuehl · Accepted solution]

Try

Sum({$<Day= {'Monday'}, Category_ID -= {'11','12'} >} Sales)

[#3]

It works fine, but it underlines in red the first { it shows, this affects the result?

[swuehl]

The part after the minus-equal sign is underlined in red? This is a bug in the syntax checker, no need to worry.

The expression dialog should state "Expression OK" above the expression input box.

[v_iyyappan]

HI,

No, It does not affect the result. because its say expression is ok and only syntax error is occurred default in qlikview. So dont worry about it.

Regards,