# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

## Set Analysis Question

Hello All,

I have 4 fields

WeekPlantNet PriceOrder Quantity
1BID123.0016
1BID122.0014
1CAL124.0012
1TAP120.0022
2TER133.0041
3REP127.0015

So set analysis which I am struck in is I want the calculation of PAN locations on the same week

Ex.

If I select week 1 and Plant BID1 so a table should show me same week but Plant CAL1 and TAP1 order quantity Calculations and total value(order qty. * net price) excluding BID1.

Do help!

Tags (3)
1 Solution

Accepted Solutions
Partner

## Re: Set Analysis Question

Hi Sid,

Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])

4 Replies
Partner

## Re: Set Analysis Question

Hi Sid,

Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])

Highlighted
Contributor III

## Re: Set Analysis Question

Hi,

Is that what you want to get?

Highlighted
Not applicable

## Re: Set Analysis Question

Thanks to both of you kaan and Coen

Coen given me one correct and Kaan given me for second

thanks a ton both of you.

Also may I know what this P stands for?

Highlighted
Contributor III

## Re: Set Analysis Question

P is Possible and E is Excluded