Set Analysis Help

Fri, 18 Mar 2016 22:58:02 GMT

I need help with two set analysis expressions.

Set Analysis One:

The expression needs to return the Sum of Sales and Only include sales from fields RPI(field name) equals to "Off Premise" and WEEK(field name) equal to 4.

Set Analysis Two:

The expression needs to look up the "Targets" table and sum the Current Month Sales (field name) and only include sales from fields RPI (field name) equal to "On Premise" and Region(field name) equal to 5.

Re: Set Analysis Help

alexdataiq — Fri, 18 Mar 2016 23:54:52 GMT

Maybe:

Sum({<RPI={'Off Premise'}, WEEK={4}>} Sales)

Sum({<RPI={'On Premise'}, Region={5}>} [Current Month Sales])

topic Set Analysis Help in QlikView

Set Analysis Help

Re: Set Analysis Help